Re: [GENERAL] data modeler

2004-09-27 Thread Chris Mair
> > Druid? http://druid.sourceforge.net/ > > from reading the description, it looks like they might have something, > but there is *no* documentation and i can't figure out how they want > me to run the install jar file. java -jar druid-3.5-install.jar Bye, Chris. ---

[GENERAL] .net

2004-09-27 Thread Federico Balbi
Hi, I was wondering if the .net connector for pgsql works fine on Visual C# on PocketPC 2002/2003 too. Any comments on past experiences is truly appreciated. Thanks, Fed ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [GENERAL] Getting an out of memory failure.... (long email)

2004-09-27 Thread Sean Shanny
Tom, We have been running pg_autovacuum on this entire DB so I did not even consider that. I am running an analyze verbose now. We should see about 82mm rows that will match the Filter: ((date_key >= 610) AND (date_key <= 631)) I'll update in an hour or so. --sean On 9/27/04 11:49 PM, "Tom L

Re: [GENERAL] Getting an out of memory failure.... (long email)

2004-09-27 Thread Tom Lane
Sean Shanny <[EMAIL PROTECTED]> writes: > -> Seq Scan on f_pageviews t1 (cost=0.00..11762857.88 > rows=1 width=8) > Filter: ((date_key >= 610) AND (date_key <= 631)) How many rows are actually going to match that filter condition? (The symptoms seem

Re: [GENERAL] Foreign key order evaluation

2004-09-27 Thread Michael Fuhr
On Mon, Sep 27, 2004 at 03:19:47PM -0400, Shawn Chisholm wrote: > > Hi, I am trying to deal with a deadlock situation caused by foreign > key references on insert and I was wondering if anyone knows what > order the foreign keys are locked (or evaluated) in for a particular > table? Deferring the

[GENERAL] Getting an out of memory failure.... (long email)

2004-09-27 Thread Sean Shanny
To all, Running into an out of memory error on our data warehouse server. This occurs only with our data from the 'September' section of a large fact table. The exact same query running over data from August or any prior month for that matter works fine which is why this is so weird. Note that J

[GENERAL] renaming sequences

2004-09-27 Thread Matthew Hixson
I had a bunch of tables that had v_ prepended to their names. I've renamed all of the tables so that they don't have that prefix anymore so that v_address is now addresses. The name of this table's sequence is still v_addresses_address_id_seq. This is fine except for the fact that I'm using

Re: [GENERAL] PostgreSQL 8.0.0 Beta 3 Uploaded

2004-09-27 Thread Marc G. Fournier
On Mon, 27 Sep 2004, Robby Russell wrote: On Mon, 2004-09-27 at 16:29, Marc G. Fournier wrote: Its been almost 4 weeks since we've released Beta2, and there have been enough improvements to the code to warrant a new Beta, to reduce the number of "already fixed" bug reports. For a complete list of c

Re: [GENERAL] PostgreSQL 8.0.0 Beta 3 Uploaded

2004-09-27 Thread Robby Russell
On Mon, 2004-09-27 at 16:29, Marc G. Fournier wrote: > Its been almost 4 weeks since we've released Beta2, and there have been > enough improvements to the code to warrant a new Beta, to reduce the > number of "already fixed" bug reports. > > For a complete list of changes/improvement since Beta

[GENERAL] PostgreSQL 8.0.0 Beta 3 Uploaded

2004-09-27 Thread Marc G. Fournier
Its been almost 4 weeks since we've released Beta2, and there have been enough improvements to the code to warrant a new Beta, to reduce the number of "already fixed" bug reports. For a complete list of changes/improvement since Beta 1 was released, please see: ftp://ftp.postgresql.org/pub/

[GENERAL] Aggregates ?? Datamart (to whatever it has implemented a DataMart using Postgres)

2004-09-27 Thread Esteban Kemp
This is the Problem:     I'm building a Large DataMart with a big table and I want to improve the performace using aggregates I mean a set of table that store some specific aggregacion of the main table, like materialized views, I know that this feature is not implemented yet in postgres, And

Re: [GENERAL] core dump on select

2004-09-27 Thread John Liu
Core dump on select from psql on AIX 5.x I have the following task at hand - A huge table, one of the column data has duplicated entries. I want to find those duplicated records in this column - select count(*), col-x from table-x group by col-x having count(*) >1; Of course, the above query wi

Re: Null comparisons (was Re: [GENERAL] checksum)

2004-09-27 Thread David Helgason
On 27. sep 2004, at 22:08, Dean Gibson (DB Administrator) wrote: Greg Stark wrote on 2004-09-27 08:17: Stephan Szabo <[EMAIL PROTECTED]> writes: >> On Sun, 26 Sep 2004 20:16:52 +0200, David Helgason <[EMAIL PROTECTED]> wrote: >>> On a similar note, I've found myself wanting an extended '=' operat

Re: Null comparisons (was Re: [GENERAL] checksum)

2004-09-27 Thread Dean Gibson (DB Administrator)
Even simpler: COALESCE( a = b, a IS NULL AND b IS NULL ) -- Dean Greg Stark wrote on 2004-09-27 08:17: Stephan Szabo <[EMAIL PROTECTED]> writes: > > On Sun, 26 Sep 2004 20:16:52 +0200, David Helgason <[EMAIL PROTECTED]> wrote: > > > > On a similar note, I've found myself wanting an extended '=' op

[GENERAL] Foreign key order evaluation

2004-09-27 Thread Shawn Chisholm
Hi, I am trying to deal with a deadlock situation caused by foreign key references on insert and I was wondering if anyone knows what order the foreign keys are locked (or evaluated) in for a particular table? Deferring the locks is unfortunately not a good option for me... Thanks, Shawn