Re: [GENERAL] table count limitation

Marcin Inkielman wrote: > On Sat, 26 Aug 2000, Jurgen Defurne wrote: > > > Date: Sat, 26 Aug 2000 07:36:25 +0200 > > From: Jurgen Defurne <[EMAIL PROTECTED]> > > To: Marcin Inkielman <[EMAIL PROTECTED]> > > Cc: postgreSQL general mailing list <[EMAIL PROTECTED]> > > Subject: Re: [GENERAL] table c

Re: [GENERAL] split up tables or one big one?

Patrick, Any time your design is heading in this direction, take a good hard look at it. Proper organization with the appropriate indexes is the way to go. With tens of hundreds of tables, how will you decide which to use? How will you write your queries? Customize them for the different tables?

[GENERAL] Local Users "su'ing" (REPOST)

Hi, Don't think this made it the first time... Thanks, Andrew -- Forwarded message -- Date: Sat, 26 Aug 2000 15:45:55 +1000 (EST) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Local Users "su'ing" Hi, I'm running postgresql 7.0.2 under FreeBSD 4.1-STABLE. If a user r

Re: [GENERAL] creating functions

Stephan Szabo wrote: > > > but I received this as the error: > > -- > > ERROR: Unrecognized language specified in a CREATE FUNCTION: > > 'plpgsql'. Recognized languages are sql, C, internal and the > > created > > procedural languages. > >

Re: [GENERAL] creating functions

> but I received this as the error: > -- > ERROR: Unrecognized language specified in a CREATE FUNCTION: > 'plpgsql'. Recognized languages are sql, C, internal and the > created > procedural languages. >

[GENERAL] creating functions

Hi All, I'm trying to create a function that takes an interval (in seconds) and returns HH:MM:SS similar to reltime() but not dividing down to num# days,months etc... anyway, I've been looking into the CREATE FUNCTION routines and here I struck a stumbling block. I tried(from the doco):

Re: [GENERAL] Stripping a prefix

On Fri, Aug 25, 2000 at 09:28:59PM -0700, Ian Turner wrote: > If the string is like `^www\.', then trim `w' and `.'. But this trims all 'w's and all '.'s, even if the string doesn't start with 'www.': select trim(leading 'www.' from 'wfoo'); ltrim --- foo (1 row) I ended up writing a func

Re: [GENERAL] split up tables or one big one?

it all depends on what the data is and how you are going to use it ... if its going to result in this major JOIN to get results, or several queries, you are best with teh multi-GB table ... On Sat, 26 Aug 2000, Patrick Goodwill wrote: > Hi! > > I'm writing a system which i could logically se

[GENERAL] split up tables or one big one?

Hi! I'm writing a system which i could logically separate it into hundreds, perhaps thousands, of tables, or it could put it all into one big table. Since each tables could probably only grow to 10s of MBs in size, from a design, speed, and scalability perspective, is it perferable to split u

RE: [GENERAL] pgaccess not connecting

Thanks for the response. You will already have my last posting. The script, BTW, I referred to at /etc/postgresql/postmaster.init has the tag PGALLOWTCPIP=yes/no and the default is no. regards, Bill >= Original Message From Jesus Aneiros <[EMAIL PROTECTED]> = >Check the script in /etc/

[GENERAL] Re: Stripping a prefix

> Date: Fri, 25 Aug 2000 09:35:43 -0600 > From: Bruce Guenter <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Stripping a prefix > > Is there a function available to strip a string from the start of a > string? trim and ltrim can strip any occurrence of a set of characters > from th

Re: [GENERAL] pgaccess not connecting

Check the script in /etc/rc.d/init.d/postgresql it doesn't accept parameters in the command linea except start, stop, status. Change the line that runs postmaster adding -i option. -- Jesus Aneiros Sosa mailto:[EMAIL PROTECTED] http://jagua.cfg.sld.cu/~aneiros On Sat, 26 Aug 2000, Tom Lane wrote

RE: [GENERAL] pgaccess not connecting

That's it. Found the switch in /etc/postgresql/postmaster.init. Thank you very much, Bill >= Original Message From Tom Lane <[EMAIL PROTECTED]> = >Bill Barnes <[EMAIL PROTECTED]> writes: >> kgb10:/home/billb# /etc/init.d/postgreql start -i >> Starting PostgreSQL postmaster >> kgb10:/home

[GENERAL] php + postgres7x

I've recently installed postgres 7.0.2 and after a few tries everything is working though, I'm trying to compile php w/ and I can't get past where php is looking for postgres even though I've told it where it is. Is there something I'm doing wrong?   Mike

Re: [GENERAL] pgaccess not connecting

Bill Barnes <[EMAIL PROTECTED]> writes: > kgb10:/home/billb# /etc/init.d/postgreql start -i > Starting PostgreSQL postmaster > kgb10:/home/billb# ps ax | grep postmaster > 24746 pts/5S 0:00 /usr/lib/postgresql/bin/postmaster -b > /usr/lib/postgresql/bin/postgres -B 1

Re: [GENERAL] Help on analyzing performance problem.

"Travis Bauer" <[EMAIL PROTECTED]> writes: > I have a problem with a _very_ slow query. I'm not sure how to understand > the explain output. There's some basic info about EXPLAIN in the "understanding performance" section of the user manual (at least today, it's at http://www.postgresql.org/docs

[GENERAL] pgaccess not connecting

Running Debian 2.2. Had to reinstall postgresql 7.02 Can access database with psql but not pgaccess. The log that follows is from a stop and restart of postmaster. Script started on Sat Aug 26 01:17:33 2000 kgb10:/home/billb# /etc/init.d/postgresql stop Stopping PostgreSQL postmaster Stopped /us

[GENERAL] Help on analyzing performance problem.

I have a problem with a _very_ slow query. I'm not sure how to understand the explain output. Can anyone tell from the following where I might look for a bottleneck in the system? Thank, Travis psql:test.sql:1: NOTICE: QUERY PLAN: Nested Loop (cost=3.03..240.90 rows=4 width=124) -> Neste