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,
I
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 definitely
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
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
then
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
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);
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 probably
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;
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 I
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 that
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 hit in
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 to write
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
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
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 postgresql
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
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 fsync'd,
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 postgres
18 matches
Mail list logo