Hello!I use FreeBSD 4.11 with PostGreSQL 7.3.8.I got a huge database with roughly 19 million records. There is just onetable, with a time field, a few ints and a few strings.table testfields time (timestamp), source (string), destination (string), p1 (int),
p2 (int)I have run VACUUM ANALYZE ;I have
database=> set enable_seqscan to on;
SET
Time: 0.34 ms
database=> explain analyze select count(*) from test where p1=53;
QUERY PLAN
--
On 6/22/05, Tobias Brox <[EMAIL PROTECTED]> wrote:
> [Kjell Tore Fossbakk - Wed at 09:45:22AM +0200]
> > database=> explain analyze select count(*) from test where p1=53 and
> > time > now() - interval '24 hours' ;
>
> Sorry to say that I have not followed t
> Try to type in '2005-06-21 16:36:22+08' directly in the query, and see if it
> makes changes. Or probably '2005-06-21 10:36:22+02' in your case ;-)
Which one does Pg read fastes? Does he convert datetime in the table,
then my where clause and check, for each row? How does he compare a
datetime
I cant get the config file to load into my postgres. that's the
problem. I want to set it to 10k, but it is only still at 1000... I
save the file and restart the service..
yes, i ment 'pg_ctl reload', sry about that one.
kjell tore
On 6/22/05, Bricklen Anderson <[EMAIL PROTECTED]> wrote:
> >> en
, none of the options are changed (with a restart of the postmaster). I cant find a '--configuration=path/file' option for the postmaster either...
Kjell Tore
On 6/22/05, Tobias Brox <[EMAIL PROTECTED]> wrote:
[Kjell Tore Fossbakk - Wed at 07:41:54AM -0700]> I cant get the config f
-- Forwarded message --From: Kjell Tore Fossbakk <[EMAIL PROTECTED]>Date: Jul 26, 2006 8:55 AM
Subject: Performance with 2 AMD/Opteron 2.6Ghz and 8gig DDR PC3200To: [EMAIL PROTECTED]Hello!I have upgraded my server to an HP Proliant DL585. It got two Processor motherboards
28 juli 2006 11:17To: Mikael Carneholm; Kjell Tore Fossbakk;pgsql-performance@postgresql.orgSubject: RE: [PERFORM] Performance with 2 AMD/Opteron
2.6Ghz and 8gigMikael,> -Original Message-> From: Mikael Carneholm [mailto:[EMAIL PROTECTED]]> Sent: Friday, July 28, 2006 2:05 AM
Hello.OS: Gentoo 2006.0 with gentoo's hardened kernelVersion: I haven't checked. Im guessing 8.0.8 (latest stable on all systems) or 8.1.4 which is the latest package.I'm still gonna try to run with smart array 5i. How can i find out that my performance with that is crappy? Without ripping down my
--From: Kjell Tore Fossbakk [mailto:
[EMAIL PROTECTED]]Sent: Sunday, July 30, 2006 03:03 PM Eastern Standard TimeTo: Claus GuttesenCc: pgsql-performance@postgresql.orgSubject:Re: [PERFORM] Performance with 2 AMD/Opteron
2.6Ghz and 8gig DDR PC3200Hello.OS: Gentoo 2006.0 with ge
Hello!I got two AMD Opteron 885 processors (2.6ghz) and 8 gig of memory.Harddrives are 4 scsi disks in 10 raid.I'm running gentoo, and the kernel finds and uses all of my 2 (4) cpu's.How can i actually verify that my PostgreSQL (or that my OS) actually gives each new query a fresh idle CPU) all of
11 matches
Mail list logo
