In article <[EMAIL PROTECTED]>, Florian G. Pflug <[EMAIL PROTECTED]> wrote:
% You could try doing:
%
% begin;
% select 1;
% select 1;
% ...
% rollback;
Yes, I tried that, but each select is on the order of 100ms.
% off. If that doesn't reveal a possible cause, then I'd suggest that
% you strace
Patrick TJ McPhee wrote:
% Patrick TJ McPhee wrote:
[...]
[the query is "select 1"]
% > But if I turn on duration logging, I get timings like
% > LOG: duration: 91.480 ms
The logs and data are all one file system, which seems to be on a logical
volume with a single disk sitting under it.
Flor
In article <[EMAIL PROTECTED]>,
Joshua D. Drake <[EMAIL PROTECTED]> wrote:
% Patrick TJ McPhee wrote:
[...]
[the query is "select 1"]
% > But if I turn on duration logging, I get timings like
% > LOG: duration: 91.480 ms
[...]
% Vacuum? Analyze?
I had autovacuum on initially, but turned it off
Patrick TJ McPhee wrote:
I have a Red Hat ELsmp system running on a dual opteron hp server with
16 gigs of memory. I believe the RH installation is straight out of the
box. I've compiled postgres 8.1.4 from sources.
The problem is that query performance is horrible, and I can't think
why, althou
Patrick,Have you modified your postgresql.conf file or is this default out-of-the-box too? Are the database and database logs (pg_xlog) on shared disc space?SteveOn 8/28/06,
Patrick TJ McPhee <[EMAIL PROTECTED]> wrote:
I have a Red Hat ELsmp system running on a dual opteron hp server with16 gigs o
Patrick TJ McPhee wrote:
I have a Red Hat ELsmp system running on a dual opteron hp server with
16 gigs of memory. I believe the RH installation is straight out of the
box. I've compiled postgres 8.1.4 from sources.
The problem is that query performance is horrible, and I can't think
why, althou
I have a Red Hat ELsmp system running on a dual opteron hp server with
16 gigs of memory. I believe the RH installation is straight out of the
box. I've compiled postgres 8.1.4 from sources.
The problem is that query performance is horrible, and I can't think
why, although it seems clear the probl
