Hi all, I'm pretty new to SQL and databases in general.
I'm getting some strange hapenings with a table, that is taking about 2-3 seconds to respond to a SELECT * query under psql after a couple of days running.
The table only had 5 rows, 2 columns of simple string & int, yet was taking a while to query.
Other much larger tables would respond straight away, with no delay.
Dropping, creating and repopulating the table and the problem goes away for a few more days.
Design/Structure is:
Runing PostgreSQL 7.1.2, on Solaris 8.
Table A (no delays) several columns, including unique column 'callsign'
Table B (has delays) 2 columns, 'callsign' and 'status'
Both A and B have indexes created using the unique 'callsign'.
A has a trigger function that calls a function that inserts/updates B to change the status (status for NEW, DELETED, UPDATED etc)
There is only one client app using table B, several clients writing/reading on table A.
Two different installs, both experience the same problem on this table. Is there some sort of locking hapening when writing to the table within the function that i need to be careful of?
Any assistance greatly appreciated.
I'm getting some strange hapenings with a table, that is taking about 2-3 seconds to respond to a SELECT * query under psql after a couple of days running.
The table only had 5 rows, 2 columns of simple string & int, yet was taking a while to query.
Other much larger tables would respond straight away, with no delay.
Dropping, creating and repopulating the table and the problem goes away for a few more days.
Design/Structure is:
Runing PostgreSQL 7.1.2, on Solaris 8.
Table A (no delays) several columns, including unique column 'callsign'
Table B (has delays) 2 columns, 'callsign' and 'status'
Both A and B have indexes created using the unique 'callsign'.
A has a trigger function that calls a function that inserts/updates B to change the status (status for NEW, DELETED, UPDATED etc)
There is only one client app using table B, several clients writing/reading on table A.
Two different installs, both experience the same problem on this table. Is there some sort of locking hapening when writing to the table within the function that i need to be careful of?
Any assistance greatly appreciated.