Can I get some feedback from the group? Should a long or short version
be used in the FAQ?
>
> How about the full answer? I think Tom did a fantastic job of writing up,
> be a shame to make it go to waste for brevity? :(
>
> On Sat, 27 Jan 2001, Bruce Momjian wrote:
>
> > OK, how is this?
>
The Hermit Hacker <[EMAIL PROTECTED]> writes:
> How about the full answer? I think Tom did a fantastic job of writing up,
> be a shame to make it go to waste for brevity? :(
Perhaps someone would like to polish the answer into a section in the
Administrator's Guide? Then the FAQ answer could st
How about the full answer? I think Tom did a fantastic job of writing up,
be a shame to make it go to waste for brevity? :(
On Sat, 27 Jan 2001, Bruce Momjian wrote:
> OK, how is this?
>
>
> These are the limits:
>
> Maximum size for a database? unlimited (60GB databases exis
Richard Bayet writes:
> How do I set up (here, to extend it) the maximum number of clients for a
> database ?
Use the -N option.
> I start postmaster with 'postmaster -i -N 16' (I can't use more than 16
> due to the IPC sys V blabla ...).
Time to do something about the IPC sys V blablah then.
How do I set up (here, to extend it) the maximum number of clients for a
database ?
I start postmaster with 'postmaster -i -N 16' (I can't use more than 16
due to the IPC sys V blabla ...).
I know N is the number of backend server processes, but does it have a
result on the maximum number of clien
Hello there,
I have a DB that I am attempting to buy "the right hardware" for.
This DB today is about 25GB total, with typical tables in the area of 3GB in
size, and up to about 20 million records per table for the big tables.
Is there any set of recommendations for sizing a DB using PostgreSQL
OK, how is this?
These are the limits:
Maximum size for a database? unlimited (60GB databases exist)
Maximum size for a table?64 TB on all operating systems
Maximum size for a row? unlimited in 7.1 and later
Maximum si
Bruce, I think section 4.6 of the FAQ is a tad on the short and overly
optimistic side. Here's a set of more precise statements ...
4.6) What is the maximum size for a row, table, database?
Maximum size for a database?
Effectively unlimited, although you may see performance problems w
In psql, type \dS. This will report all the system tables.
For example:
Select * from pg_tables;
Will select info on all your tables.
Here is a link that describes most of the system tables:
http://www.postgresql.org/devel-corner/docs/postgres/catalogs.htm
-Original Message-
Fro
> Am Samstag, 27. Januar 2001 00:20 schrieb Bruce Momjian:
> > > Have you looked at the replication code that is in contrib?
> >
> > Yes, your description sounds just like it.
>
> Hmm, which of the two? The trigger mechanism?
The triggers.
>
> In the meantime, a third solution came to my mind:
> Maximum size for a row?
>unlimited in 7.1 and later
> Maximum number of rows in a table?
>unlimited
> Maximum number of columns in a table?
>unlimited
> Maximum number of indexes on a table?
>
I've looked at psql and found good stuff, but I still don't know how to get a
listing of all my tables. I know in Oracle it's a SELECT statement, and I take
it for granted a lot of admin is done with regular SQL commands, where can I
learn such stuff as how to list my tables?
LB
set nomail
Am Samstag, 27. Januar 2001 00:20 schrieb Bruce Momjian:
> > Have you looked at the replication code that is in contrib?
>
> Yes, your description sounds just like it.
Hmm, which of the two? The trigger mechanism?
In the meantime, a third solution came to my mind:
In case somebody has to take a
Am Donnerstag, 25. Januar 2001 19:07 schrieb The Hermit Hacker:
> Have you looked at the replication code that is in contrib?
Oops, not yet. In 7.0.3 or current?
Bye...
Dirk
* Bogdan Paduraru <[EMAIL PROTECTED]> [010127 01:27] wrote:
> Hello ,
> I made a tool with Java servlets and Postgresql. This tool inputs html text
> into a db. My problem is that everytime I input text that contains '
> (apostrophe)
> I get an SQL exception.
> This Postgresql can't see by itse
Hello ,
I made a tool with Java servlets and Postgresql. This tool inputs html text
into a db. My problem is that everytime I input text that contains '
(apostrophe)
I get an SQL exception.
This Postgresql can't see by itself what is the difference ?
I don't want to check every character, this
Hi,
The FAQ says:
_
4.6) What is the maximum size for a row, table,
database?
These are the limits:
Maximum size for a database?
unlimited (60GB databases exist)
Maximum size for a table?
18 matches
Mail list logo
