I have a large table (5M items current) that is projected to grow at
the rate of 2.5M a month looking at the current usage trends.
the table represents some core standardized user account attributes ,
while text heavy / unstandardized info lies in other tables.
my issue is this: i'm adding
Jonathan Vanasco wrote:
> I have a large table (5M items current) that is projected to grow at the
> rate of 2.5M a month looking at the current usage trends.
>
> the table represents some core standardized user account attributes ,
> while text heavy / unstandardized info lies in other tables.
>
Dear all,
Thanks for your advices. I'd like to ask you where can I download the
pg_buffercache add-on and also where can I find some documentation about how
can I install it?
Thank you
Sorin
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Moran
Sent
In response to "Sorin N. Ciolofan" <[EMAIL PROTECTED]>:
>
> Dear all,
>
> Thanks for your advices. I'd like to ask you where can I download the
> pg_buffercache add-on and also where can I find some documentation about how
> can I install it?
It's part of the contrib directory that ships with th
Try importing your file using psql. Once you have that working, it
might help you understand why it is failing with phppgadmin. I
thought phppgadmin used pg_restore to restore files. Does pg_restore
really work on SQL files, or just binary files? I don't recall offhand.
John
On Apr 15, 2
At one point the databases we had in a machine used 10 million plus page
slots. We made the number of page slots 14 million.
After a few large system were phased out we now only use about 2 million
page slots. Other than hard disk space, are there any disadvantages on
having a large number of
> Other than hard disk space, are there any disadvantages on
> having a large number of page slots?
It's not using hard disk space, it's using shared memory, so you might
want to adjust it to make that memory available for other purposes...
> DETAIL: A total of 2233472 page slots are in use (in
Francisco Reyes wrote:
At one point the databases we had in a machine used 10 million plus page
slots. We made the number of page slots 14 million.
After a few large system were phased out we now only use about 2 million
page slots. Other than hard disk space, are there any disadvantages on
h
Thomas F. O'Connell wrote:
> On Apr 17, 6:56 pm, [EMAIL PROTECTED] (Bruce Momjian) wrote:
> > CAJ CAJ wrote:
> > > Hello,
> >
> > > What is the ETA of postgresql 6.2.4? Also, will pg_standby make
> it to
> > > 8.2.xbranch?
> >
> > pg_standby will not be in 8.2.X. It is a new feature.
>
>
On 4/17/07, Terry Martin <[EMAIL PROTECTED]> wrote:
I am using redhat and RTOS.
The packets with be coming in on a 1 GBPS port and the information is
streaming UDP packets coming in.
I need it real time.
With RH ulogd should be possible; RTOS I don't know at all.
And it will need a grunty
Sorry, it took so long to build a test case, but I think I have
something reproducible that won't be a burden to transport.
What made this problem even more strange was that if my tables only
contained the record I was calculating with, then the problem would not
manifest.
So, I have strip
Hi,
I've been given a task to build a couple of geographically separate
servers, which are capable of replicating data between each other.
I've surfed through various google results, and most of what I've found
seems to be a bit dated, so I thought I'd pose my question here, perhaps
for more de
To answer your question meaningfully, you need to provide more details.
What are you trying to get out of "replication"? High availability? Load
sharing?
On Wed, 18 Apr 2007, Drew Myers wrote:
Hi,
I've been given a task to build a couple of geographically separate
servers, which are capable
In response to "Drew Myers" <[EMAIL PROTECTED]>:
>
> I've been given a task to build a couple of geographically separate
> servers, which are capable of replicating data between each other.
>
> I've surfed through various google results, and most of what I've found
> seems to be a bit dated, so
On Apr 18, 2007, at 4:28 AM, Alban Hertroys wrote:
I got some good results using bitwise operations on an integer column.
An index on such a column helps a great deal of course. What type of
integer you need depends on how many booleans you (expect to) have.
My operations were like "WHERE (val
Dear List,
I would like to download the version of source code containing
catversion.h with the line "#define CATALOG_VERSION_NO 200611051". This
is first met in Changeset 26624
(https://projects.commandprompt.com/public/pgsql/changeset/26624)
How could I download it?
--
Tisztelettel: / G
Andrew Toth wrote:
> Dear List,
>
> I would like to download the version of source code containing
> catversion.h with the line "#define CATALOG_VERSION_NO 200611051". This
> is first met in Changeset 26624
> (https://projects.commandprompt.com/public/pgsql/changeset/26624)
>
> How could I downl
Andrew Toth wrote:
Dear List,
I would like to download the version of source code containing
catversion.h with the line "#define CATALOG_VERSION_NO 200611051". This
is first met in Changeset 26624
(https://projects.commandprompt.com/public/pgsql/changeset/26624)
How could I download it?
On 4/15/07, Anton Melser <[EMAIL PROTECTED]> wrote:
it might even make more sense), and with KDE/Gnome these days, I don't
think there is much difference with XP...
Of course you could use fluxbox, twm or something else less
bloated ... my window-manager has a 2MB foot-print.
Or use vim instea
Hi guys,
I just installed the latest release of Postgres (8.2 native version) on
Win XP Pro). When I try to run psql through Cygwin, I cannot get to the
postgres terminal. I mean I type in the password, and the feeling is
that it just hangs.
It all works fine from Windows terminal.
Any idea
am Wed, dem 18.04.2007, um 23:25:07 -0400 mailte Sergei Dubov folgendes:
> Hi guys,
>
> I just installed the latest release of Postgres (8.2 native version) on
> Win XP Pro). When I try to run psql through Cygwin, I cannot get to the
I'm not familiar with this crappy os, but since version 8.0
I would like to do a selective export of a number of tables from a large
database to import into a smaller (test) DB.
I know about: psql dbname -tc "select * from tableX where whatever" >
tableX.dat
but unless I put it through a sed script, this file cannot be easily used
for import.
It feels
am Wed, dem 18.04.2007, um 21:59:35 -0700 mailte chrisj folgendes:
>
> I would like to do a selective export of a number of tables from a large
> database to import into a smaller (test) DB.
>
> I know about: psql dbname -tc "select * from tableX where whatever" >
> tableX.dat
>
> but unless I
Chris,
> I know about: psql dbname -tc "select * from tableX where whatever" >
> tableX.dat
What about
psql $DATABASEHOST -U $DATABASEUSER -d $DATABASE -q -P footer -A -F , -c
"$DETAIL_SQL" >table.csv
To produce a comma separated file of tuples only.
If I'm not mistaken, as happens quite a bit
Sergei Dubov wrote:
Hi guys,
I just installed the latest release of Postgres (8.2 native version) on
Win XP Pro). When I try to run psql through Cygwin, I cannot get to the
postgres terminal. I mean I type in the password, and the feeling is
that it just hangs.
If you are running 8.2 native
On Wed, 18 Apr 2007 23:25:07 -0400, Sergei Dubov <[EMAIL PROTECTED]> wrote:
> I just installed the latest release of Postgres (8.2 native version) on
> Win XP Pro). When I try to run psql through Cygwin, I cannot get to the
> postgres terminal. I mean I type in the password, and the feeling is
>
26 matches
Mail list logo
