On Thursday 09 Dec 2004 10:37 am, JM wrote:
> Hi ALL,
>
> Im wondering sooner or later my disk will be filled-up by postgres's
> data..
>
> Can anyone give some suggestion on how to deal with this. In oracle you
> can just assign tables on a diff partition.
You could use tablespaces in post
ra ghu wrote:
> Sir,
>
> I have installed postgres in my standalone pc and PGAdmin -III,i am
> able to start postgresql server and it is running,but when i try to
> connect to postgreserver from pgadmin i am geting
>
> Error connecting to server
>
> Is the server running on host 127.0.0.1 and
Seeking advice on system configuration (and I have read the techdocs.)
We are converting a data collection system from Oracle to PostgreSQL
8.0. We are currently getting about 64 million rows per month; data is
put into a new table each month. The number of simultaneous connections
is very small:
Lonni J Friedman <[EMAIL PROTECTED]> writes:
> OK, thanks. So is there any real benefit in doing this in a generic
> (non-dspam) sense, or is it just a hack that wouldn't be noticable?
> Any risks or potential problems down the line?
OIDs increase the storage requirements so they do slow postg
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> One of the things on the TODO list is making the size of temp-table
>> buffers user-configurable. (Temp table buffers are per-backend, they
>> are not part of the shared buffer arena.) With a large temp-table arena
>> we'd never need
Tom Lane wrote:
> Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> > I don't think temporary tables have any special rules regarding disk
> > writes, so I'd expect them ot get written out like everything else.
>
> They'll be written out from PG's internal buffers, but IIRC they will
> never be
On Sun, 2004-12-12 at 20:25 -0800, Lonni J Friedman wrote:
> OK, thanks. So is there any real benefit in doing this in a generic
> (non-dspam) sense, or is it just a hack that wouldn't be noticable?
> Any risks or potential problems down the line?
It saves 4 bytes per row; depending on alignment
Larry White wrote:
> How 'ready for prime-time' is the table inheritance feature? I've
> seen some postings about particular issues (lack of full FK support,
> for example), but would like to get an overall sense of the stability
> and robustness of the feature.
>
> Also, is there a performance h
On Sun, 12 Dec 2004 22:16:27 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Lonni J Friedman <[EMAIL PROTECTED]> writes:
> > The spam filtering package I use (dspam) had a section in their
> > release notes recently which stated that disabling OIDs greatly
> > increased speeds, and so they suggested
Lonni J Friedman <[EMAIL PROTECTED]> writes:
> The spam filtering package I use (dspam) had a section in their
> release notes recently which stated that disabling OIDs greatly
> increased speeds, and so they suggested that people do that on their
> tables.
"greatly increased"? I doubt it.
Last
The spam filtering package I use (dspam) had a section in their
release notes recently which stated that disabling OIDs greatly
increased speeds, and so they suggested that people do that on their
tables.
When creating new tables, you can disable OIDs with,
CREATE TABLE foo (...) WITHOUT OIDS;
And
Phil Endecott <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> In principle, therefore, the kernel could hold temp table data in its
>> own disk buffers and never write it out to disk until the file is
>> deleted. In practice, of course, the kernel doesn't know the data is
>> transient and will pr
On Sat, Dec 11, 2004 at 12:30:30PM +, NosyMan wrote:
> I want to know that is a posibillity to test if a statement is prepared in
> PL/PgSQL.
>
> I have create a function:
> .
> PREPARE PSTAT_SAVE_record(INTEGER, INTEGER, DATE, VARCHAR) AS INSERT INTO
> table VALUES($1, $2, $3, $4)
Sir,
I have installed postgres in my standalone pc and PGAdmin -III,i am able to start postgresql server and it is running,but when i try to connect to postgreserver from pgadmin i am geting
Error connecting to server
Is the server running on host 127.0.0.1 and accepting TCP/IP connections on
Dear Mr. Fuhr,
Thank you for prompt follow up.
Fitst of all, I need to remind you that presently we are working on Windows
OS (Windows XP-Professional). The errors occured when installing PostgreSQL
on the above OS.
Upon research I found out that I "MAY" require to install "Cygwin" first and
th
Tom Lane wrote:
They [temporary tables]
> will be written out from PG's internal buffers, but IIRC they will
never be fsync'd, and they definitely aren't WAL-logged. (These
statements hold true in 8.0, but not sure how far back.)
In principle, therefore, the kernel could hold temp table data in it
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> I don't think temporary tables have any special rules regarding disk
> writes, so I'd expect them ot get written out like everything else.
They'll be written out from PG's internal buffers, but IIRC they will
never be fsync'd, and they definitel
I don't think temporary tables have any special rules regarding disk
writes, so I'd expect them ot get written out like everything else. The
database doesn't know you're going to delete them later.
Are the tables big?
On Thu, Dec 09, 2004 at 10:10:21PM +, Phil Endecott wrote:
> Dear All,
>
>
18 matches
Mail list logo
