I'm running into some performance problems trying to execute simple
queries.
postgresql version 7.3.3
.conf params changed from defaults.
shared_buffers = 64000
sort_mem = 64000
fsync = false
effective_cache_size = 40
ex. query: select * from x where id in (select id from y);
There's an inde
Hello,
We're running a set of Half-Life based game servers that lookup user
privileges from a central PostgreSQL 7.3.4 database server (I recently
ported the MySQL code in Adminmod to PostgreSQL to be able to do this).
The data needed by the game servers are combined from several different
tab
On Wed, Aug 27, 2003 at 09:02:25PM +0530, Shridhar Daithankar wrote:
> IIRC in a kernel release note recently, it was commented that IO scheduler is
> still being worked on and does not perform as much for random seeks, which
> exaclty what database needs.
Yeah, I've read that as well. It would
Hi all,
I did some benchmarking using pgbench and postgresql CVS head, compiled
yesterday.
The results are attached. It looks like 2.6.0-test4 does better under load but
under light load the performance isn't that great. OTOH 2.4.20 suffer major
degradation compare to 2.6. Looks like linux is
matt wrote:
Are you sure? Have you tested the overall application to see if possibly
you gain more on insert performance than you lose on select performanc?
Unfortunately dropping any of the indexes results in much worse select
performance that is not remotely clawed back by the improvement in
ins
So there are no settings for PG to can give me this same (fast) capability
just by issuing a SQL statement thru the ODBC driver?
The reason I can't go the route of a DECLARE CURSOR is because my
application runs on multiple databases, so I have stay clear of certain
routines that may are may not b
On 26 Aug 2003 at 8:34, Jeff wrote:
> Could it just be that the sun sucks? (And for the record - same schema,
> nearly same query (modified for datetime syntax) on informix runs in 3
> seconds).
My impression is IPC on sun has higher initial latency than linux. But given
that you also ran the te
Hi all,
Hopefully a quick query.
Is there anything special I should look at when configuring either
PostgreSQL and Linux to work together on an 8-way Intel P-III based system?
I currently have the database system running fairly nicely on a 2 CPU
Pentium-II 400 server with 512MB memory, hardwar
I'm wondering if the good people out there could perhaps give me some
pointers on suitable hardware to solve an upcoming performance issue.
I've never really dealt with these kinds of loads before, so any
experience you guys have would be invaluable. Apologies in advance for
the amount of info be
