On Jun 14, 2007, at 8:16 AM, Michael Fuhr wrote:
On Thu, Jun 14, 2007 at 06:10:15PM +0530, Shyam Sunder Rai wrote:
How can I calculate a table size in postgres ?
To find the size of an existing table use pg_relation_size() or
pg_total_relation_size() (8.1 and later; in earlier versions use
the
On Thu, Jun 14, 2007 at 06:10:15PM +0530, Shyam Sunder Rai wrote:
> How can I calculate a table size in postgres ?
To find the size of an existing table use pg_relation_size() or
pg_total_relation_size() (8.1 and later; in earlier versions use
the functions in contrib/dbsize).
http://www.postgre
Hello,
On Thu, 14 Jun 2007 18:10:15 +0530 Shyam Sunder Rai wrote:
> How can I calculate a table size in postgres ?
thats in the docu:
Docu -> The SQL Language -> Functions and Operators ->
System Administration Functions
http://www.postgresql.org/docs/8.2/interactive/functions-admin.html
K
Hi,
How can I calculate a table size in postgres ?
Help please..
Regards,
Shyam Sunder Rai
"Benjamin Krajmalnik" <[EMAIL PROTECTED]> writes:
> I was playing around trying to tweak the performance of the database.
> As part of the process, I increased the number of WAL buffers to 32 and
> the checkpoint segments to 16.
> That appears to have been the culprit! I set them back at the same
this
behavior?
Thanks in advance.
Benjamin
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Rodrigo De Leon
> Sent: Thursday, July 13, 2006 7:08 PM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Table size growing for no r
On 7/13/06, Benjamin Krajmalnik <[EMAIL PROTECTED]> wrote:
I am running PostgreSQL 8.1.4 on windows.
I have a table with the following structure:
CREATE TABLE "public"."tblksaura" (
"ksaurasysid" SERIAL,
"testtime" TIMESTAMP WITHOUT TIME ZONE,
"lasthouralive" DOUBLE PRECISION[],
"last2
I am running
PostgreSQL 8.1.4 on windows.
I have a table with
the following structure:
CREATE TABLE
"public"."tblksaura" ( "ksaurasysid" SERIAL, "testtime"
TIMESTAMP WITHOUT TIME ZONE, "lasthouralive" DOUBLE PRECISION[],
"last24hrsalive" DOUBLE PRECISION[], "last7daysalive"
DOUB
Dear Sir,
I would like to know how can I find the size of a table in Oracle.
regards,
Karthik.S.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Wed, 31 May 2000, HENAFF Mari-mai FTRD/DMI/LAN wrote:
> I read that postgres table size is unlimited.
> But, a postgres table is stored into a file, and the size of a file is
> limited to approximately 2 Giga Bytes under Linux.
The table will be split into two (or more) files at gigabyte boun
Norbert Meissner wrote:
>
> > > How do you go beyond 2gigs on a single file on ext2fs (like
> > > the major linux distributions delivering) ? magic?
> >
> > Split the files into 1 gig segments.
> >
>
> Excuse my dumb questions, but is this a capability of linux or postgresql ?
> Can you point me
> > > How do you go beyond 2gigs on a single file on ext2fs (like
> > > the major linux distributions delivering) ? magic?
> >
> > Split the files into 1 gig segments.
> >
>
> Excuse my dumb questions, but is this a capability of linux or postgresql ?
> Can you point me to a location where i can
> > How do you go beyond 2gigs on a single file on ext2fs (like
> > the major linux distributions delivering) ? magic?
>
> Split the files into 1 gig segments.
>
Excuse my dumb questions, but is this a capability of linux or postgresql ?
Can you point me to a location where i can read more ?
Tha
> >
> >
> > What PostgreSQL version are you running? We are able to go >2 gigs. I
> > think some have 10 gig tables, even on Linux. What version are you
> > using?
>
> How do you go beyond 2gigs on a single file on ext2fs (like
> the major linux distributions delivering) ? magic?
Split the fi
>
>
> What PostgreSQL version are you running? We are able to go >2 gigs. I
> think some have 10 gig tables, even on Linux. What version are you
> using?
How do you go beyond 2gigs on a single file on ext2fs (like
the major linux distributions delivering) ? magic?
Norbert
> Hi Mari,
>
> as far as i know is the table size limited through the size of
> int4 (=size of oid, 32 Bits). This means that you can have an
> amount 4 "Gigarows" in one table.
>
> There are some people working on the 2 GB Limitation on the
> Linux filesystem. I remember an article about this i
Hi Mari,
as far as i know is the table size limited through the size of int4 (=size of
oid, 32 Bits). This means that you can have an amount 4 "Gigarows" in one table.
There are some people working on the 2 GB Limitation on the Linux filesystem. I
remember an article about this in a german compu
I read that postgres table size is unlimited.
But, a postgres table is stored into a file, and the size of a file is
limited to approximately 2 Giga Bytes under Linux.
I tried to test this by inserting hundreds of thousands of rows into a table
: my insert queries failed when the file containing
18 matches
Mail list logo
