Hi,
Ive observed this:
Here is output from PostgreSQL 7.1.2:
trapdb=# select cast(datetime(1057637700) as timestamp);
?column?
---
2003-07-08 09:45:00+05:30
(1 row)
Here is output from PostgreSQL 7.2.4:
trapdb=# select cast(datetime
Hi all,
I have a problem :
A select statement that selects from 7 tables,
groups the information by 6 columns of the
tables involved.
When there are no rows in pg_statistics,
the query runs under 3 minutes.
When I analyze the biggest table of the 7
(approx 100 rows), the query takes longer
What OS, if Linux what kernel
-Original Message-
From: Wilson A. Galafassi Jr. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 6:51 AM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
Hello.
I have this problem: i'm running the postgre 7.3 on a
Scott Cain wrote:
Oh, and I forgot to mention: it's highly compressed (bzip2 -9) and is
109M.
Thanks. I'll grab a copy from home later today and see if I can find
some time to poke at it.
Joe
---(end of broadcast)---
TIP 1: subscribe and unsubscr
Joe,
Good idea, since I may not get around to profiling it this week. I
created a dump of the data set I was working with. It is available at
http://www.gmod.org/string_dump.bz2
Thanks,
Scott
On Mon, 2003-08-04 at 16:29, Joe Conway wrote:
> Is there a sample table schema and dataset available
Title:
We recently upgraded from version 7.2.3 to 7.3.3 and seem to have some code
that has broken. We were doing checks in various locations looking for nulls
and/or empty fields. To search for empty fields we said something like
select count(am_pk) from array
