[GENERAL] Database performance

1999-04-15 Thread Christopher Hutton
Hello all, My database seems to be functioning much slower than I would expect of even the worst database. Can anyone point me towards any fine tuning that I can do(i.e. documentation, web sites, comentary). Thanks Very Much.

Re: [GENERAL] The WWW of PostgreSQL

1999-04-15 Thread Simon Drabble
On Thu, 15 Apr 1999, Adriaan Joubert wrote: > The Hermit Hacker wrote: > > > > > > I don't want to create a polemic, but is it possible to make a > > > recovery of the previous WWW interfaces of the postgreSQL.org site? > > > What does an elephant do on the home page? Probably you have been > > >

Re: [GENERAL] The WWW of PostgreSQL

1999-04-15 Thread Adriaan Joubert
The Hermit Hacker wrote: > > > > I don't want to create a polemic, but is it possible to make a > > recovery of the previous WWW interfaces of the postgreSQL.org site? > > What does an elephant do on the home page? Probably you have been > > hacked :-) > > The elephant surrounded by the diamond h

[GENERAL] Re: case problem with MS Access export

1999-04-15 Thread Glenn Waldron
If anyone's interested, it turns out a good temporary fix to this problem involves only two lines of SQL: update pg_class set relname = lower(relname); update pg_attribute set attname = lower(attname); This seems to work without any side effects. enjoy- glenn > > I've seen this question elsewh

[GENERAL] Re: what is the MAX postgres db size & table size? NOBODY KNOWS?

1999-04-15 Thread The Hermit Hacker
On Thu, 15 Apr 1999, valter wrote: > The Hermit Hacker wrote: > > > there is a max? *raised eyebrow* > > > > i've not understand! > > in Sysbase the limit is 8 Tera Byte, in Mysql a table cannot be much than 2 or 4 > Gb ... > what are the postgresql LIMITS? At this point in time, we are not a

Re: [GENERAL] The WWW of PostgreSQL

1999-04-15 Thread The Hermit Hacker
On Thu, 15 Apr 1999, darold wrote: > Hi all, > > > I don't want to create a polemic, but is it possible to make a > recovery of the previous WWW interfaces of the postgreSQL.org site? > What does an elephant do on the home page? Probably you have been > hacked :-) The elephant surrounded by th

Re: [GENERAL] what is the MAX postgres db size & table size? NOBODY KNOWS?

1999-04-15 Thread Brett W. McCoy
On Thu, 15 Apr 1999, valter wrote: > The Hermit Hacker wrote: > > > there is a max? *raised eyebrow* > > > > i've not understand! > > in Sysbase the limit is 8 Tera Byte, in Mysql a table cannot be much than 2 or 4 > Gb ... > what are the postgresql LIMITS? I think it's dependent on the opera

[GENERAL] what is the MAX postgres db size & table size? NOBODY KNOWS?

1999-04-15 Thread valter
The Hermit Hacker wrote: > there is a max? *raised eyebrow* > i've not understand! in Sysbase the limit is 8 Tera Byte, in Mysql a table cannot be much than 2 or 4 Gb ... what are the postgresql LIMITS?

Re: [GENERAL] How to get seq after insert]

1999-04-15 Thread Karl DeBisschop
On Thu, 15 Apr 1999, Bruce Momjian wrote: > > On Wed, 14 Apr 1999, Michael Davis wrote: > > > > > The safest way is to select the nextval('seq_name') and then insert using > > > this value. > > > > I understand, I just thought something like, I do the insert, and then > > grab the value with:

[GENERAL] The WWW of PostgreSQL

1999-04-15 Thread darold
Hi all, I don't want to create a polemic, but is it possible to make a recovery of the previous WWW interfaces of the postgreSQL.org site? What does an elephant do on the home page? Probably you have been hacked :-) The previous logo was the good one., If you need help to design a new interface

Re: [GENERAL] what is the max postgres db size & table size?

1999-04-15 Thread The Hermit Hacker
there is a max? *raised eyebrow* On Thu, 15 Apr 1999, valter wrote: > valter > > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org

[GENERAL] case problem with MS Access export

1999-04-15 Thread Glenn Waldron
I've seen this question elsewhere on the list, but no good answer. I am exporting large databases from MS Access to PG, but the table and column names come out as case-sensitive in PG and I need to quote them in order for PG to see them. select * from table tab1; gives an error because the table

[GENERAL] what is the max postgres db size & table size?

1999-04-15 Thread valter
valter