Hi,
How much Ram do you have ?
Could you give us your postgresql.conf ? (shared buffer parameter)
If you do lots of deletes/inserts operations you HAVE to vacuum analyze
your table (especially if you have indexes).
I'm not sure if vacuuming locks your table with pg 7.4.2 (it doesn't with
8.0
I would suggest something like this, don't know how fast it is ... :
SELECT (ID +1) as result FROM my_table
WHERE (ID+1) NOT IN (SELECT ID FROM my_table) as tmp
ORDER BY result asc limit 1;
"Merlin Moncure" <[EMAIL PROTECTED]>
Envoyé par : [EMAIL PROTECTED]
28/06/2005 16:21
Pour :
On our production server, I can insert 5000 tuples in 2100 ms.
Single Xeon 2.6 Ghz
2 Gigs ram
3ware RAID 5 SATA drives array, 3 drives only :-((
PG 8.0 - fsync off
I do think inserting 5000 tuples in a second (i.e 5000 insert transactions, no bulk load) can be reached with well a configured SC
Unfortunately.
But we are in the the process to choose Postgresql with pgcluster. I'm currently running some tests (performance, stability...)
Save the money on the license fees, you get it for your hardware ;-)
I still welcome any advices or comments and I'll let you know how the project is g
hi all.
We are designing a quite big application that requires a high-performance database backend.
The rates we need to obtain are at least 5000 inserts per second and 15 selects per second for one connection. There should only be 3 or 4 simultaneous connections.
I think our main concern is t
I must say that cygwin did well (there exists good software on windows, i've found one)... as a prototype ... when I look at the postgresql poll (http://www.postgresql.org/survey.php?View=1&SurveyID=11), it seems like I'm not alone !!
Actually, the major problem was the limit of the available allo
Thanks a lot Scott.
It seems that we were totally wrong when considering a network storage solution. I've read your techdoc http://techdocs.postgresql.org/guides/DiskTuningGuide and found many interesting remarks.
I think that we will know focus on external Raid systems which seem to be relativi
Hi all,
I've been searching the list for a while but couldn't find any up-to-date information relating to my problem.
We have a production server with postgresql on cygwin that currently deels with about 200 Gigs of data (1 big IDE drive). We plan to move to linux for some reasons I don't have to
