Nick Burrett <[EMAIL PROTECTED]> writes:
> I expected that specifying a specific length for a column would allow
> for more efficient indexing and searching because:
> a) you already know the exact length of the column
> b) potentially the column-data could be stored starting on a word-boundary
>
Holger Marzen <[EMAIL PROTECTED]> writes:
> I use PostgreSQL for counting network traffic, I use a sample every five
> minutes. Because my queries became too slow I simply added another table
> that holds the data per day. Every day, yesterday's data get added,
> inserted into the "day"-table and
On Fri, 17 Oct 2003, Nick Burrett wrote:
> > It would be worth revisiting this and trying to understand where the
> > performance problem is, rather than just assuming that you have to work
> > around it.
>
> Luckily my CVS tree has such information. Basically this database holds
> samples of the
On Fri, 17 Oct 2003 15:47:10 +0100, Nick Burrett <[EMAIL PROTECTED]>
wrote:
>CREATE TABLE fiveminute ( server CHAR(32),
> stamp TIMESTAMP,
> bytesin BIGINT CHECK (bytesin >= 0),
> bytesout BIGINT CHECK (bytesout >= 0));
>
Nick Burrett <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Have you thought about
>> collapsing these into *one* table with an extra key column? Also, it'd
>> likely be better to combine the date and time into a timestamp column.
> I tried it back in the days when we only had around 1000 table
Nick Burrett <[EMAIL PROTECTED]> writes:
> The original table definition was exactly this:
> CREATE TABLE fiveminute ( server CHAR(32),
>stamp TIMESTAMP,
>bytesin BIGINT CHECK (bytesin >= 0),
>bytesout BIGINT CHECK
Tom Lane wrote:
Nick Burrett <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
We don't normally hear of people needing that --- is there anything
unusual about the schema of this database?
Not particularly. The database consists of around 3000 tables created
using this:
CREATE TABLE vs_foo (date
Tom Lane wrote:
Nick Burrett <[EMAIL PROTECTED]> writes:
$ pg_dumpall >full.db
pg_dump: WARNING: ShmemAlloc: out of memory
pg_dump: Attempt to lock table "vs_dfa554862ac" failed. ERROR:
LockAcquire: lock table 1 is out of memory
pg_dumpall: pg_dump failed on bandwidth, exiting
Looks like you
