Carl R. Brune wrote:
I should have added that I want to make further use of the temporary
table after the COMMIT -- the rollback approach you propose makes it
go away.
In which case the transaction isn't READONLY. You have two options:
CREATE TEMPORARY TABLE ... AS SELECT ...
BEGIN READONLY;
[EMAIL PROTECTED] wrote:
I would like to create a database server with postgres web application.
My DB size will be 20GB.
I will write 1 a day with until 10 to 15 simultanous write.
How could I size my server (memory, CPU, ...) ?
The only reliable way is to do some testing. Now 10,000
On Fri, Jul 07, 2006 at 03:48:00PM +0200, Marc Haber wrote:
I am the maintainer of Debian's packages for exim4, a powerful and
versatile Mail Transfer Agent developed in Cambridge and in wide use
throughout the Free Software Community (http://www.exim.org/).
One of our daemon flavours has
On Tue, Aug 08, 2006 at 05:25:12PM -0400, Jasbinder Bali wrote:
Why I'm asking this is (though generally m/c hosting the middle tier
component can connect to the m/c hosting the Db without any DB client
installed) because i tried to run ecpg in the middle tier m/c and it doesn't
work. Well it
hi,
I'm working in the implementation of a
datawarehouse on Postgres.
For analisys of aggregated data I'd like to use
some OLAP tools like for example, Mondrian, OR use the meterialized view (if
better).
My questions:
isthere anydocumentation about
warehouse (with OLAP or materialized
The best way of finding out is to do some testing - use a standard
desktop machine (or laptop) and see how that performs. Make sure you
have a realistic mix and amount of data though.
If I had to guess, I'd buy a cheap server with some SATA disks (at least
2 so you can mirror them) and as
Jasbinder Bali wrote:
In my database server, I'm using packaged version of postgres.
I installed it using: yum install postgres and this inturn searches for
the rmp.
So, its a packaged version of postgresql.
Now as far as my client is concerned, that has the middle tier component
written in C,
is there a way to configure psql/readline so that it doesn't clear the
screen after browsing a query with 'q'?
regards,
merlin
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Wed, Aug 09, 2006 at 09:02:55AM -0400, Merlin Moncure wrote:
is there a way to configure psql/readline so that it doesn't clear the
screen after browsing a query with 'q'?
You don't say the OS, but you may be seeing the effects of less working
on a terminal with a seperate interactive screen
On Aug 9, 2006, at 9:02 , Merlin Moncure wrote:
is there a way to configure psql/readline so that it doesn't clear the
screen after browsing a query with 'q'?
Assuming you are using less as your PAGER, then see:
http://www.greenwoodsoftware.com/less/#tite
One can add the -X option to your
Hi,
I'm running PostgreSQL version 8 on a dual 2.4GHz Xeon with 1GB of RAM
and an IDE hard drive. My big table has around 9 million records.
Is there a tuning parameter I can change to increase speed of selects?
Clearly, there's already some buffering going on since selecting an
indexed
On 8/9/06, Stefano B. [EMAIL PROTECTED] wrote:
hi,
I'm working in the implementation of a datawarehouse on Postgres.
For analisys of aggregated data I'd like to use some OLAP tools like for
example, Mondrian, OR use the meterialized view (if better).
My questions:
is there any documentation
On Wed, Aug 09, 2006 at 09:19:31AM -0400, Tom Laudeman wrote:
Hi,
I'm running PostgreSQL version 8 on a dual 2.4GHz Xeon with 1GB of RAM
and an IDE hard drive. My big table has around 9 million records.
Is there a tuning parameter I can change to increase speed of selects?
Clearly,
On Wed, Aug 09, 2006 at 03:46:38PM +0200, Martijn van Oosterhout wrote:
On Wed, Aug 09, 2006 at 09:19:31AM -0400, Tom Laudeman wrote:
Is there a tuning parameter I can change to increase speed of selects?
Clearly, there's already some buffering going on since selecting an
indexed ~50,000
I'm having some trouble getting a google hit on this topic, and the docs
aren't doing much for me.
What I'm wondering is, how do I limit any particular postgres operation,
in particular a long-running batch operation with lots of inserts, from
bogging down a server?
This is not so much a
Richard Huxton dev@archonet.com writes:
Carl R. Brune wrote:
I should have added that I want to make further use of the temporary
table after the COMMIT -- the rollback approach you propose makes it
go away.
In which case the transaction isn't READONLY.
It does seem a bit inconsistent that
On Wed, 2006-08-09 at 09:02 -0400, Merlin Moncure wrote:
is there a way to configure psql/readline so that it doesn't clear the
screen after browsing a query with 'q'?
I assume you're using the less text pager on a Unix box. I think what you're seeing is less clearing the screen
Hello all.
I am
trying to build postgres from the source on a WINXP system. I am using MSVC++.Net
and I use the link with it to get to the command prompt. After I do that I run
vcvars32.bat and the nmake /f win32.mak and I get:
C:\Dev\postgresql-8.1.4\srcnmake
/f win32.mak
On 8/9/06, Reece Hart [EMAIL PROTECTED] wrote:
On Wed, 2006-08-09 at 09:02 -0400, Merlin Moncure wrote:
is there a way to configure psql/readline so that it doesn't clear the
screen after browsing a query with 'q'?
I assume you're using the less text pager on a Unix box. I think
Hi, I'm having a problem with one of my functions, where I delete all
rows containing a particular date and then re-insert a row with that
same date. When I try this I get a constraint error. This just started
recently, after upgrading our database from 7.4 to 8.1.4 (now on RH EL).
here's the
Hello,
I will be basically unavailable from this Saturday until the 21st of
August. I will be spending a long week in SF at LinuxWorld West.
Please use email to contact me if it is important.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
On 8/9/06, Ron St-Pierre [EMAIL PROTECTED] wrote:
Hi, I'm having a problem with one of my functions, where I delete all
rows containing a particular date and then re-insert a row with that
same date. When I try this I get a constraint error. This just started
recently, after upgrading our
I don't see how checkpoint_timeout is relevant. Just because we
checkpoint doesn't mean the WAL file will get archived. I have to have
16M of WAL traffic before a file gets archived regardless of
check-pointing, or am I missing something?
Right, I think ;-) If you want finer-grained backup,
What about creating views on areas of the table that are queried often?
I don't know if you have access or the ability to find what type of
trends the table has, in terms of queries, but if you create some views
on frequently visited information, this could also help.
Tom Laudeman wrote:
I too faced same kind of a problem building libpq on Windows and as a solution to it removed inline from the file
\backend\utils\mb\wchar.cDid the following ... changed static inline int to static int instead at a couple of places in the wchar.c file
Run nmake after doing this specific change and
Louis,Views certainly help in managing complexity. They do nothing to improve query-speed. Querying a view gets rewritten to queries to the underlying tables on the fly.(as long as there are no materialized views, which are still on a the TODO list)
-- GHUM Harald Massapersuadere et
Views certainly help in managing complexity. They do nothing to improve
query-speed.
Querying a view gets rewritten to queries to the underlying tables on the
fly.
(as long as there are no materialized views, which are still on a the TODO
list)
Would partial indexs on the most queried
Shoaib,
That looks like it worked thank you!
Bruce,
I am using the following compliler:
C:\Dev\postgresql-8.1.4\src\interfaces\libpq\Releasenmake --help
Microsoft (R) Program Maintenance Utility Version 7.10.3077
Copyright (C) Microsoft Corporation. All rights reserved.
Which
DEV wrote:
Shoaib,
That looks like it worked thank you!
Bruce,
I am using the following compliler:
C:\Dev\postgresql-8.1.4\src\interfaces\libpq\Releasenmake --help
Microsoft (R) Program Maintenance Utility Version 7.10.3077
Copyright (C) Microsoft Corporation. All rights
I'm not so sure about that, when you create a view on a table - at least
with Oracle - which is a subset(the trivial or 'proper' subset is the
entire table view) of the information on a table, when a select is
issued against a table, Oracle at least, determines if there is a view
already on a
Bruce Momjian [EMAIL PROTECTED] writes:
Interesting. It seem the key line is here:
cl : Command line warning D4029 : optimization is not available in the
standard edition compiler
So the standard version doesn't support inline functions.
Doesn't it simply ignore the inline keyword then?
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Interesting. It seem the key line is here:
cl : Command line warning D4029 : optimization is not available in the
standard edition compiler
So the standard version doesn't support inline functions.
Doesn't it simply ignore
Michael Fuhr wrote:
On Wed, Aug 09, 2006 at 10:33:02AM -0700, Ron St-Pierre wrote:
ERROR: duplicate key violates unique constraint systemcounts_pkey
CONTEXT: SQL statement INSERT INTO dm.systemCounts (updateDate) VALUES (
$1 ::date)
PL/pgSQL function updatesystemcounts line 8 at SQL
Title: Re: [GENERAL] Tuning to speed select
On Wed, 2006-08-09 at 14:58, louis gonzales wrote:
I'm not so sure about that, when you create a view on a table - at least
with Oracle - which is a subset(the trivial or 'proper' subset is the
entire table view) of the information on a table,
Okay I get a
build and I get the release of the libpq built but it does not build the Debug
version of that. I have tried going to the directory and running nmake /f
win32.mak DEBUG but it errors with:
Building the
Win32 static library...
NMAKE : fatal
error U1073: don't know how to
Michael,
Great suggestion. I've read about CLUSTER, but never had a chance to
use it. The only problem is that this table with 9 million records has
5 or 6 indexes. It is hard to pick the most used, but I'll bet CLUSTER
will make at least one of the queries run very fast, especially for an
On Wed, Aug 09, 2006 at 04:54:00PM -0400, Tom Laudeman wrote:
I'll try CLUSTER (I'm looking forward to that test), but if we really
need speed, it will probably be necessary to create copies of the table,
or copy portions of the table elsewhere (essentially creating
materialized views, I
Dev,You are doing it a little wrong for Debug version, in order to build the Debug version use the following:nmake /f win32.mak DEBUG=1Bruce,If you remove inline the build process goes fine and if you dont, it first gives a few warning and in the end quits the build process with a fatal error.
Log
Shoaib Mir wrote:
Dev,
You are doing it a little wrong for Debug version, in order to build the
Debug version use the following:
nmake /f win32.mak DEBUG=1
Bruce,
If you remove inline the build process goes fine and if you dont, it first
gives a few warning and in the end quits the
As a workaround if you dont want to make the change and delete inline from wchar.c then you can do the following change in the win32.mak file for libpq:You can see at line 121 in win32.mak file as:
WIN32 /D _WINDOWS /Fp$(INTDIR)\libpq.pch /YX\Change it toWIN32 /D _WINDOWS /D inline=__inline
On Wed, 2006-08-09 at 16:54 -0400, Tom Laudeman wrote:
Great suggestion. I've read about CLUSTER, but never had a chance to use it. The only problem is that this table with 9 million records has 5 or 6 indexes. It is hard to pick the most used, but I'll bet CLUSTER will make at least one
On Fri, Aug 04, 2006 at 03:46:09PM -0400, Matthew T. O'Connor wrote:
Chander Ganesan wrote:
Matthew T. O'Connor wrote:
I have done some googling for real world archive_command examples and
haven't really found anything. The example in the PGSQL Docs are
qualified by (This is an example,
On Thu, Aug 03, 2006 at 05:46:44PM -0500, Scott Marlowe wrote:
On Thu, 2006-08-03 at 17:44, John Sidney-Woollett wrote:
In addition to making sure databases are vacuumed regularly, it is worth
running REINDEX on tables that see a lot of updates (or insert/deletes).
Running REINDEX on a
On Wed, Aug 09, 2006 at 10:22:20AM -0400, Kenneth Downs wrote:
I'm having some trouble getting a google hit on this topic, and the docs
aren't doing much for me.
What I'm wondering is, how do I limit any particular postgres operation,
in particular a long-running batch operation with lots
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Bruce Momjian
Sent: Wednesday, August 09, 2006 2:19 PM
To: Shoaib Mir
Cc: DEV; pgsql-general@postgresql.org
Subject: Re: [GENERAL] WIN32 Build?
Shoaib Mir wrote:
Dev,
You are
On Aug 3, 2006, at 3:01 PM, Tom Lane wrote:
Jim Nasby [EMAIL PROTECTED] writes:
If you're using multiple timelines with PITR, do you have to re-copy
all the data files into the cluster every time you start a new
timeline? Or can you copy the data files out of the backup once, and
then perform
Jim Nasby [EMAIL PROTECTED] writes:
On Aug 3, 2006, at 3:01 PM, Tom Lane wrote:
The only way to roll time backwards is to replace the data directory
with a backup, so if I understand your question correctly, the answer
is no.
Well, specifically I was thinking of...
Roll PITR forward and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jim C. Nasby wrote:
On Thu, Aug 03, 2006 at 05:46:44PM -0500, Scott Marlowe wrote:
On Thu, 2006-08-03 at 17:44, John Sidney-Woollett wrote:
[snip]
And if you're vacuuming frequently enough, there shouldn't be
that much need to reindex.
How
On 8/8/06, Michael Fuhr [EMAIL PROTECTED] wrote:
On Tue, Aug 08, 2006 at 12:16:18PM -0700, [EMAIL PROTECTED] wrote:
I'd like to write a C Function for Postgresql that can access data in
the database, use that to conduct additional queries to find more
information in the database and
Hello All,
When we pass file name in pg_ctl (with option -l) what has to be syslog
value..
Should it be enabled..?if so what cud be the value for syslog..?
Though I have sent approprite file name with -l option ,and if I use
default value for syslog (0) then
I am getting the messages in
Also (obvsly) we aren't able to get a new connection after hitting max
fd limit..
Thx,
Prasanna.
-Original Message-
From: Mavinakuli, Prasanna (STSD)
Sent: Wednesday, August 09, 2006 10:10 AM
To: pgsql-general@postgresql.org
Cc: Mavinakuli, Prasanna (STSD)
Subject: Too many open files
Hello All,
We are using postgres with HP-UX.
Usually We will have many records,and will do vacuum once in 2 days.
We have observed that postgres opens many files in data directory
And won't close till next vacuum (I experience it)
When it hits max limit, we won't able to open any other files.
Hi,I'm trying to connect to postgres database in a distributed environment, say from machine X to Machine Y (Machine Y has postgres DB)How should my connection string look like in a program in Machine X.EXEC SQL CONNECT TO --??? (Do i need to specify the IP of DB server?)
I tried a few options
Jim C. Nasby wrote:
Take a look at http://pgfoundry.org/projects/pgpitrha/
I had already seen this however it says that this project has yet to
release any files, so I thought it was a dead project. Am I missing
something?
Also, note that in 8.1, you have to manually archive the last WAL
Jeffrey Bigham [EMAIL PROTECTED] writes:
I also have some vague understanding that C might be faster. I hope I'm
not opening a can-of-worms, but is C actually faster?
C should theoretically be faster than any of the alternatives you
mention, all else being equal (eg, you are implementing the
Hi
I already read that documentation.
My ECPG code for connecting to the DB server is:
EXEC SQL CONNECT TO 192.168.1.100:/xyz
i also tried
tcp:postgresql://192.168.1.100[:port][/dbname][
?options]
unix:postgresql://192.168.1.100[:port][
/dbname][?options]
but unfortunately it say DB
Mavinakuli, Prasanna (STSD) [EMAIL PROTECTED] writes:
We have observed that postgres opens many files in data directory
And won't close till next vacuum (I experience it)
When it hits max limit, we won't able to open any other files.
So what's the solution ..?
Reduce PG's
On Aug 8, 2006, at 8:33 PM, Jeffrey Bigham wrote:
Do you have a reason to use C instead of a higher-level language?
Not really. Basically I know C decently enough and would have to
learn PL/pgSQL (although it looks pretty easy). Perl sounds quite
attractive for the added benefit of
On Thu, Aug 10, 2006 at 12:02:24AM -0400, Harpreet Dhaliwal wrote:
I already read that documentation.
My ECPG code for connecting to the DB server is:
EXEC SQL CONNECT TO 192.168.1.100:/xyz
That format isn't shown in the documentation; the ecpg preprocessor
should fail with a syntax error
59 matches
Mail list logo
