On Thu, 1 Feb 2007 23:04:57 -0500
"Chad Wagner" <[EMAIL PROTECTED]> wrote:
> I have plenty of experience building large distributed OLTP systems and
> multi terabyte data warehouses, so you can either take the advice or leave
> it.
>
Me too, since Oracle 6, Informix and Ingres in the late 80's un
On 2/1/07, Steve Holdoway <[EMAIL PROTECTED]> wrote:
> Why would it be a "bottleneck"? If you are updating or deleting 300K a
> week, definitely make sure you take a look at autovacuum and turn it ON.
It is a potential bottleneck as I said. I am replacing between 5 and 10
percent of the data in
On Wed, 31 Jan 2007 18:45:15 -0500
"Chad Wagner" <[EMAIL PROTECTED]> wrote:
> On 1/31/07, Steve Holdoway <[EMAIL PROTECTED]> wrote:
> >
> > The table I'm concerned with at the moment have (currently) 5 million
> > rows, with a churn of about 300,000 rows a week. The table has about a
> > million h
On 1/31/07, Steve Holdoway <[EMAIL PROTECTED]> wrote:
The table I'm concerned with at the moment have (currently) 5 million
rows, with a churn of about 300,000 rows a week. The table has about a
million hits a day, which makes it the main potential bottleneck in this
database.
Why would it be
bit.
>
> My 2.2 cents (Aust. GST inclusive!)
>
> Cheers,
> -p
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Steve Holdoway
> Sent: Thursday, 1 February 2007 08:46
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] b
L PROTECTED] On Behalf Of Steve Holdoway
Sent: Thursday, 1 February 2007 08:46
To: pgsql-admin@postgresql.org
Subject: [ADMIN] blobs
I'm got the enviable task of redesigning an MySQL based project from
scratch. We need a proper rdbms for this project, and I want to use PG 8.2.
The table I
I'm got the enviable task of redesigning an MySQL based project from scratch.
We need a proper rdbms for this project, and I want to use PG 8.2.
The table I'm concerned with at the moment have (currently) 5 million rows,
with a churn of about 300,000 rows a week. The table has about a million hi
Hello,
I am building a database for company employee info/records system. I
just wanted to solicit some opinions on storage of images and documents.
I'm using PG 7.3.4 on a Slackware 9 Linux system.I anticipate that the
database will be at the bottom of a 3 tier design accessed through a web
brows
Hi All.
I would like to know if there is a smart query on system catalogs,
to read which databases have tables with blobs inside.
Thank you very much.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ot;postgres group" <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 11:54 PM
Subject: [ADMIN] BLOBs
> Is there a way to easily store images or other large files into the DB
over
> a TCP/IP network. I would prefer Access/ODBC, but I could also use
pgaccess
> if necessary. It
Is there a way to easily store images or other large files into the DB over
a TCP/IP network. I would prefer Access/ODBC, but I could also use pgaccess
if necessary. It would really be nice if there was a GUI way to do it.
Basically, I want to copy a file from my hard drive directly to a PostgreS
11 matches
Mail list logo
