What can I do about this plan?
HashAggregate (cost=8035443.21..8035445.17 rows=157 width=24)
- Nested Loop (cost=37680.95..7890528.72 rows=28982898 width=24)
suspect
Join Filter: ((a.test_run_start_date_time = date.start_time) AND
(a.test_run_start_date_time = date.end_time))
On Tue, 2 Jun 2009, Geoffrey wrote:
The problem with my current process is as noted, my script keeps looking
for the *.history file, but never sees it.
From the restore_command section of the documentation:
The command will be asked for log files that are not present in the
archive; it
On Wed, 2009-06-03 at 01:28 -0600, Scott Marlowe wrote:
On Wed, Jun 3, 2009 at 12:32 AM, Ow Mun Heng ow.mun.h...@wdc.com wrote:
HashAggregate (cost=8035443.21..8035445.17 rows=157 width=24)
- Nested Loop (cost=37680.95..7890528.72 rows=28982898 width=24)
suspect
Join Filter:
On Wed, Jun 3, 2009 at 2:18 AM, Ow Mun Heng ow.mun.h...@wdc.com wrote:
On Wed, 2009-06-03 at 01:28 -0600, Scott Marlowe wrote:
On Wed, Jun 3, 2009 at 12:32 AM, Ow Mun Heng ow.mun.h...@wdc.com wrote:
HashAggregate (cost=8035443.21..8035445.17 rows=157 width=24)
- Nested Loop
Hi all,
Is there any plan to make 0.83 stable release?
Maybe some roadmap / plans on the website would help, just to
give an idea of the future versions (availability, features).
Thanks!
Seb
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Sebastien FLAESCH wrote:
Hi all,
Is there any plan to make 0.83 stable release?
What is 0.83? That's not a PostgreSQL version number.
Maybe some roadmap / plans on the website would help, just to
give an idea of the future versions (availability, features).
Version 8.4 is currently in
On Wed, Jun 3, 2009 at 3:42 AM, Sebastien FLAESCH s...@4js.com wrote:
Hi all,
Is there any plan to make 0.83 stable release?
If you mean postgresql 8.3, it was stable when 8.3.0 came out.
Maybe some roadmap / plans on the website would help, just to
give an idea of the future versions
Oups sorry wrong mailing list.
Wanted to ask about next FreeTDS release.
I apologies,
Seb
PS: It's just to take data from an SQL Server and store it with
PostgreSQL, I promise ;-)
Sebastien FLAESCH wrote:
Hi all,
Is there any plan to make 0.83 stable release?
Maybe some roadmap / plans on
Hello Bruce,
I am specifically looking for the Datenbanksystemidentifikation , that
would be database system identification - the rather unique ID of a
database installation. Third line in pg_controldata output:
pg_control-Versionsnummer:833
Katalogversionsnummer:
On Wed, Jun 3, 2009 at 12:32 AM, Ow Mun Heng ow.mun.h...@wdc.com wrote:
What can I do about this plan?
HashAggregate (cost=8035443.21..8035445.17 rows=157 width=24)
- Nested Loop (cost=37680.95..7890528.72 rows=28982898 width=24)
suspect
Join Filter:
I am using PL/Python to make queries via SPI. This seems to work when the
query is made directly, but when I pass a function as a callback to an external
module (in this case, python's cheetah templating engine), the function fails
thusly:
=# select common.template(8963,1);
ERROR: plpython:
Joshua D. Drake wrote:
On Tue, 2009-06-02 at 19:44 -0400, Geoffrey wrote:
pg_standby it self isn't a solution for warm standby. It is a component
thereof. Also don't use SCP. Use rsync. Take a look at walmgr or
PITRTools it will make your life easier.
I still don't understand why the
Thank you Greg for taking the time to explain this as throughly as you
have. I have found a logic problem in my code. I still don't know if
we will use pg_standby as the wrapper code in PITRTools is python and we
are not a python shop. Kinda want to stick with what we know (C, perl,
shell).
Hello.
I´m trying to build a cursor for postgres but I have some problems. Can
anybody send me an example of cursor in postgres?
Thanks.
Ing. Esneiker Enriquez Cabrera.
Excelencia en Software.
Desoft S.A. en Ciego de Ávila.
Joaquín de Agüero Esq. Calle 2. Ciego de Ávila. Cuba.
On Wed, Jun 03, 2009 at 08:13:48AM -0400, Geoffrey wrote:
I'm certainly looking at rsync rather then scp, which really makes more
sense.
You can mix ssh and rsync. The man pages has this example:
rsync -az -e ssh --delete ~ftp/pub/samba/ nimbus:~ftp/pub/tridge/samba
--
Sent via
On Wed, Jun 03, 2009 at 09:36:18AM -0400, Esneiker wrote:
I'm trying to build a cursor for postgres but I have some problems. Can
anybody send me an example of cursor in postgres?
What about these examples?
http://www.postgresql.org/docs/8.3/interactive/plpgsql-cursors.html
- Josh /
Hi,
I have finally found out why I have had images that lag on the website. It
seems to be that postgre is doing allot of I/O activity and the images is
somehow suffering because of this.
The strange part about this is that it seems to be allot more disk writes
than disk reads. Even though 99.9%
On Wed, Jun 3, 2009 at 9:36 AM, Esneiker eenriq...@cav.desoft.cu wrote:
Hello.
I´m trying to build a cursor for postgres but I have some problems. Can
anybody send me an example of cursor in postgres?
In perl:
$dbh-begin_work();
$dbh-do('DECLARE c1 NO SCROLL CURSOR FOR SELECT
move postgresql to another disc if possible. You have really slow
discs if that happen, or perhaps it does loads of seq scans, because
of lack of indices.
All in all, it seems like your server is to low spec for what you are
trying to do.
--
Sent via pgsql-general mailing list
In response to Jennifer Trey jennifer.t...@gmail.com:
I have finally found out why I have had images that lag on the website. It
seems to be that postgre is doing allot of I/O activity and the images is
somehow suffering because of this.
The strange part about this is that it seems to be
Hi:
A superuser cannot vacuum tables. The error message is WARNING: skipping
thetable --- only table or database owner can vacuum it
The superuser was defined like this...
create role cover_super SUPERUSER LOGIN;
grant allon database cover to cover_super;
grant all privileges on
I accidentally replied only to Grzegorz before so I don't think it turned up
on the mailing list. Here it is again. (Bill, I will try to answer your
email in a minute) ---
Thank you for you answer :)
2009/6/3 Grzegorz Jaśkiewicz gryz...@gmail.com
move postgresql to another disc if possible.
I
2009/6/3 Jennifer Trey jennifer.t...@gmail.com:
Not sure about that Grzegorz, its a pretty powerful computer :) and I don't
have that much data and traffic yet..
Normally, should the writes really be more than the reads?
Intel Quad Core 2.4 GHz
8GB Memory
Asus P5B Motherboard (Standard
Gauthier, Dave dave.gauth...@intel.com writes:
A superuser cannot vacuum tables. The error message is WARNING: skipping
thetable --- only table or database owner can vacuum it
Are you *certain* the active role is really a superuser? I'd say that
that message is sufficient proof that it
On Wed, Jun 3, 2009 at 5:13 PM, Bill Moran wmo...@potentialtech.com wrote:
In response to Jennifer Trey jennifer.t...@gmail.com:
I have finally found out why I have had images that lag on the website.
It
seems to be that postgre is doing allot of I/O activity and the images is
somehow
On Wed, Jun 3, 2009 at 4:03 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
Grzegorz, yes, you are right. I would not recommend Windows Server to
anyone either. I am to weak on linux and thought that this was going to make
my life easier. Have had lots of issues. I might be trying Ubuntu
In response to Jennifer Trey jennifer.t...@gmail.com:
* If you are doing complex queries with sorting and don't have enough RAM,
PostgreSQL will have to create temporary files. See the config variable
log_temp_files:
If I were to upgrade the database version, would I need to dump and restore
all the data?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
if you upgrade to different major version, yes. If between minor
releases (say 8.1.4-8.1.5) than no, with few exceptions. Make sure
you read release notes between versions to find out.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
In response to Carlos Oliva car...@pbsinet.com:
If I were to upgrade the database version, would I need to dump and restore
all the data?
If you upgrade patch releases (i.e. from 8.3.4 - 8.3.5) then usually no,
but see the release notes for the versions you're upgrading, because there
are
Ian Haywood ihayw...@iinet.net.au writes:
It seems as soon as execution leaves the main function access to SPI is lost.
Is this correct or a bug?
What this probably means is that plpython is failing to use
SPI_push/SPI_pop properly --- these should be called around
any operation that might
Carlos Oliva oli...@earthlink.net writes:
Would the backup be unrecoverable if I shutdown the databse first?
If the backup includes pg_xlog and pg_clog, as well as all of the
database metadata files, then whatever portions *are* included are
likely to be somewhat usable.
The portions not
pribram pribram wrote:
postgres=# SET lc_messages=cs;select to_char('2006/01/01'::timestamp,
'TMMonth');
SET
to_char
-
January
Hmm, it works fine for me (not Windows though):
alvherre=# SET lc_messages='C';select to_char('2006/01/01'::timestamp,
'TMMonth');
SET
to_char
For large databases or tables, this will take a long time to do. Are there
any alternatives to benefit from the improved versions of PostgreSQL without
having to dump some large tables that never change?
Bill Moran wmo...@potentialtech.com wrote in message
Thank you for your response Chris. It is helping us a great deal to
understand the issues around backups. Would any of the pg_xlog, pg_clog,
etc change for a table that has a stable structure and data? That is, the
table undergoes several inserts and then it is never updated.
Chris Browne
Would I need to upgrade the entire cluster or can I just upgrade database
wise?
Grzegorz Jaskiewicz gryz...@gmail.com wrote in message
news:2f4958ff0906030845t526db574q464c17072fadd...@mail.gmail.com...
if you upgrade to different major version, yes. If between minor
releases (say 8.1.4-8.1.5)
lol, if I had a nickel for every one that said they had a dollar I'd buy a
Ferrari F430 :P
but I do.. most of my memory isn't being used.. and I have once had a deep
discussion on tuning postgres on this mailing list. Feel free to search on
my name and you will see it :)
But I have gotten even
Sorry.. the formatting got screwed.. here it is again :
-
lol, if I had a nickel for every one that said they had a dollar I'd buy a
Ferrari F430 :P
but I do.. most of my memory isn't being used.. and I have once had a deep
discussion on tuning postgres on this mailing list. Feel free to
Tom,
Since you know this are well. Do you know if there is some kind of
records filtering use by PostgreSQL when selecting system objects? For
example, I run this query by PostgreSQL user.
select count(*) from information_schema.table_privileges;
I get 445 rows return.
I ran the same query
Hello,
We have a system that allows users to create views containing
calculations but divisions by zero are commonly a problem.
An simple example calculation in SQL would be
SELECT cost / pack_size AS unit_cost from products;
Either variable could be null or zero.
I don't think there's a
On Jun 3, 2009, at 5:13 AM, Geoffrey wrote:
Thank you Greg for taking the time to explain this as throughly as
you have. I have found a logic problem in my code. I still don't
know if we will use pg_standby as the wrapper code in PITRTools is
python and we are not a python shop. Kinda
Louis Lam louis@guardium.com writes:
Since you know this are well. Do you know if there is some kind of
records filtering use by PostgreSQL when selecting system objects? For
example, I run this query by PostgreSQL user.
select count(*) from information_schema.table_privileges;
The
Hi Alvaro,
thanks for testing.
Your SQL commands don't work for me:
postgres=# SET lc_messages='C';select to_char('2006/01/01'::timestamp,
'TMMonth');
SET
to_char
-
January
(1 °ßdka)
postgres=# SET lc_messages='fr_CA';select to_char('2006/01/01'::timestamp,
'TMMonth');
SET
to_char
On Wed, Jun 3, 2009 at 9:18 PM, Oliver Kohll - Mailing Lists
oliver.li...@gtwm.co.uk wrote:
Hello,
We have a system that allows users to create views containing calculations
but divisions by zero are commonly a problem.
An simple example calculation in SQL would be
SELECT cost /
Erik Jones wrote:
On Jun 3, 2009, at 5:13 AM, Geoffrey wrote:
Thank you Greg for taking the time to explain this as throughly as you
have. I have found a logic problem in my code. I still don't know if
we will use pg_standby as the wrapper code in PITRTools is python and
we are not a
Tom,
This sound pretty ugly. Are you saying that there is no way I can
select all the rows for views in the information_schema, unless I am the
database owner or superuser? in the server? I can't just grant a user
some type of system view privileges to override this feature like other
database
On Wed, 2009-06-03 at 14:43 -0400, Geoffrey wrote:
pg_standby is in no way dependent on PITRTools. PITRTools is, however,
dependent on pg_standby. Put another way: you do not need to use
PITRTools to use pg_standby. In fact, you also don't need any perl or
shell scripts to use
On Wed, Jun 3, 2009 at 5:11 PM, Carlos Oliva car...@pbsinet.com wrote:
Would I need to upgrade the entire cluster or can I just upgrade database
wise?
Obviously whole installation has to be dumped and restored. Wether you
are going to dump database by database, or do pg_dumpall, is up to
Joshua D. Drake wrote:
On Wed, 2009-06-03 at 14:43 -0400, Geoffrey wrote:
pg_standby is in no way dependent on PITRTools. PITRTools is, however,
dependent on pg_standby. Put another way: you do not need to use
PITRTools to use pg_standby. In fact, you also don't need any perl or
shell
Woudl it be possible to keep the current postgresql version running in a
different port, install a new version of postgresql, and copy the data from
one version to the other while both versions are running? This might give
us time to copy the tables and databases one at a time and reconfigure
In response to Carlos Oliva car...@pbsinet.com:
Woudl it be possible to keep the current postgresql version running in a
different port, install a new version of postgresql, and copy the data from
one version to the other while both versions are running? This might give
us time to copy
On Wed, Jun 3, 2009 at 8:03 PM, Carlos Oliva car...@pbsinet.com wrote:
Woudl it be possible to keep the current postgresql version running in a
different port, install a new version of postgresql, and copy the data from
one version to the other while both versions are running? This might give
On Wed, Jun 3, 2009 at 8:14 PM, Bill Moran wmo...@potentialtech.com wrote:
In response to Carlos Oliva car...@pbsinet.com:
Woudl it be possible to keep the current postgresql version running in a
different port, install a new version of postgresql, and copy the data from
one version to the
On Wed, 3 Jun 2009, Geoffrey wrote:
My assumption was that since pg_standby does not have the scp/rsync
functionality, I would have to either modify it, change the way we do things,
or 'reinvent' a little different wheel.
There are three things to setup here:
1) archive_command on the
In response to Grzegorz Jaśkiewicz gryz...@gmail.com:
On Wed, Jun 3, 2009 at 8:14 PM, Bill Moran wmo...@potentialtech.com wrote:
In response to Carlos Oliva car...@pbsinet.com:
Woudl it be possible to keep the current postgresql version running in a
different port, install a new version
Hi there,
seems I don't understand how FOUND variable in pl/pgsql function defined,
when I use EXECUTE of PERFORM. There is no problem when I use plain SQL.
Below is a test I did for 8.4beta2. This is simplified script and I can
use plain SQL, but in my project I need EXECUTE.
CREATE TABLE db
Hmm, I just noticed the same write behavior on my Windows Xp laptop but the
values was a little less.
I even created an DB with one table and column and this still happened
when queering it.
The problem here is the number of I/O writes. From 15 to 30... with lots of
users this is becoming an
On Wed, Jun 3, 2009 at 8:41 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
Are you sure that moving to Linux will solve this? Could you please check if
you notice the same write behavior? Any other windows users that noticed
this?
Never used postgresql on windows myself, but from what I read
Are you not confused somewhere??
First you insert INSERT INTO db VALUES(1,'one');
Then you do this :
SELECT merge_db(1, 'two');
But for some reason this SQL select * from db; selects two for your
text field...
Ries
On Jun 3, 2009, at 2:42 PM, Oleg Bartunov wrote:
Hi there,
seems I
2009/6/3 Jennifer Trey jennifer.t...@gmail.com:
Not sure about that Grzegorz, its a pretty powerful computer :) and I don't
have that much data and traffic yet..
Normally, should the writes really be more than the reads?
Intel Quad Core 2.4 GHz
8GB Memory
Asus P5B Motherboard (Standard
In response to Jennifer Trey jennifer.t...@gmail.com:
Hmm, I just noticed the same write behavior on my Windows Xp laptop but the
values was a little less.
I even created an DB with one table and column and this still happened
when querying it.
By created, you mean you created a table and
Grzegorz Jaskiewicz gryz...@gmail.com wrote in message
news:2f4958ff0906031214k3dfaa4b2mae5733d7345f7...@mail.gmail.com...
On Wed, Jun 3, 2009 at 8:03 PM, Carlos Oliva car...@pbsinet.com wrote:
Woudl it be possible to keep the current postgresql version running in a
different port, install a
Alvaro Herrera wrote:
Hmm, it works fine for me (not Windows though):
The lc_messages setting is broken in 8.3 under Windows (not sure whether this
will be fixed in 8.4):
http://archives.postgresql.org/pgsql-bugs/2008-11/msg00117.php
Rainer
--
Sent via pgsql-general mailing list
Can the synchronization with Slony run while the old database is still being
updated daily? I am wondering if we can just let Slony run until the
databases are fully synchronized and then switch databases.
Bill Moran wmo...@potentialtech.com wrote in message
On Wed, 2009-06-03 at 15:07 -0400, Geoffrey wrote:
You are still going to need to either:
A. Reinvent the wheel, by scripting it all yourself
B. Use solutions that are already used by others such as walmgr or
pitrtools
My assumption was that since pg_standby does not have the
On Wed, June 3, 2009 12:59, Bill Moran wrote:
In response to Jennifer Trey jennifer.t...@gmail.com:
Hmm, I just noticed the same write behavior on my Windows Xp laptop but
the
values was a little less.
I even created an DB with one table and column and this still happened
when querying it.
In response to Carlos Oliva car...@pbsinet.com:
Can the synchronization with Slony run while the old database is still being
updated daily? I am wondering if we can just let Slony run until the
databases are fully synchronized and then switch databases.
Yes, and yes. That's exactly what
On Wed, Jun 3, 2009 at 10:59 PM, Bill Moran wmo...@potentialtech.comwrote:
In response to Jennifer Trey jennifer.t...@gmail.com:
Hmm, I just noticed the same write behavior on my Windows Xp laptop but
the
values was a little less.
I even created an DB with one table and column and this
On Wednesday 03 June 2009 15:26, Greg Smith wrote:
On Wed, 3 Jun 2009, Geoffrey wrote:
My assumption was that since pg_standby does not have the scp/rsync
functionality, I would have to either modify it, change the way we do
things, or 'reinvent' a little different wheel.
There are three
Hola a todos.
Estoy haciendo una función en postgres que inserta datos en varias tablas,
pero son varios miles de datos. Lo que quiero hacer es utilizar
transacciones para que haga persistente los datos por partes, que no se
hagan persistentes al final.
Entonces la duda que tengo es cómo
On Wed, June 3, 2009 13:44, Jennifer Trey wrote:
On Wed, Jun 3, 2009 at 10:59 PM, Bill Moran
wmo...@potentialtech.comwrote:
In response to Jennifer Trey jennifer.t...@gmail.com:
Hmm, I just noticed the same write behavior on my Windows Xp laptop
but
the
values was a little less.
I
On Wed, 2009-06-03 at 16:45 -0400, Terry Lee Tucker wrote:
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD
Our circumstance here is that we will be feeding multiple warm stand-by
servers; one local and the rest remote, that is, at least one in other state
On Wednesday 03 June 2009 17:11, Joshua D. Drake wrote:
On Wed, 2009-06-03 at 16:45 -0400, Terry Lee Tucker wrote:
--
* Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore,
MD
Our circumstance here is that we will be feeding multiple warm stand-by
servers; one local
Oleg Bartunov o...@sai.msu.su writes:
seems I don't understand how FOUND variable in pl/pgsql function defined,
when I use EXECUTE of PERFORM. There is no problem when I use plain SQL.
EXECUTE doesn't affect FOUND, even if the statement-to-be-executed would
have. There's been some discussion
Bill, did you see my last message on the mailing list? I have tracked down
the file. Is this some statistics file? Could this be a bug caused by auto
vacuum being on?
In response to Tim Bruce - Postgres postg...@tbruce.com:
Tim, yes, I am using the tool ProcessExplorer from the windows site. It
shows all the activity but can't see to where those writes are being done
with that tool. Any ideas?
FileMon
--
Bill Moran
http://www.potentialtech.com
No, I still don't know whats being written.
I have tried to isolate it, and checked several folders, but can't
find the path.
I don't do much on Windows, but when I needed to associate
In response to Jennifer Trey jennifer.t...@gmail.com:
Bill, did you see my last message on the mailing list? I have tracked down
the file. Is this some statistics file? Could this be a bug caused by auto
vacuum being on?
I didn't see any message saying which file was getting all the activity.
On Jun 3, 1:04 am, wmo...@potentialtech.com (Bill Moran) wrote:
In response to Dave Clarke pigwi...@gmail.com:
I have a table that I'm trying to refactor and I'm by no means a SQL
expert (apologies if I'm posting to the wrong group). The table in
question has a column that allows
Hmm.. I doesn't look it made it to the mailing list. I guess you can't
attach a file then.
Finally!
I did use the programs suggested by Michael, but I actually found it a
little before you wrote :P
Filtering out with the pid showed that it was the file
pgdata/global/pgstat.tmp
See the
In response to Jennifer Trey jennifer.t...@gmail.com:
Hmm.. I doesn't look it made it to the mailing list. I guess you can't
attach a file then.
Finally!
I did use the programs suggested by Michael, but I actually found it a
little before you wrote :P
Filtering out with the pid showed
On Wed, 3 Jun 2009, Tom Lane wrote:
Oleg Bartunov o...@sai.msu.su writes:
seems I don't understand how FOUND variable in pl/pgsql function defined,
when I use EXECUTE of PERFORM. There is no problem when I use plain SQL.
EXECUTE doesn't affect FOUND, even if the statement-to-be-executed
The research is based on hypotheses and assumptions which in the end can
be discarded or not. I do not know these things, I am taking one step at
time, learning and trying.
I don't understand what kind of research you want me to do. I don't have any
performance problem other than that images seems
On Wed, Jun 3, 2009 at 3:46 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
Hmm.. I doesn't look it made it to the mailing list. I guess you can't
attach a file then.
Finally!
I did use the programs suggested by Michael, but I actually found it a
little before you wrote :P
Filtering
Jennifer Trey jennifer.t...@gmail.com wrote:
The research is based on hypotheses and assumptions which in the end can
be discarded or not. I do not know these things, I am taking one step at
time, learning and trying.
I don't understand what kind of research you want me to do.
I'm surprised
On Wed, Jun 3, 2009 at 6:54 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Wed, Jun 3, 2009 at 3:46 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
Hmm.. I doesn't look it made it to the mailing list. I guess you can't
attach a file then.
Finally!
I did use the programs suggested
Massa, Harald Armin wrote:
Hello Bruce,
I am specifically looking for the Datenbanksystemidentifikation , that
would be database system identification - the rather unique ID of a
database installation. Third line in pg_controldata output:
pg_control-Versionsnummer:833
2009/6/4 Oleg Bartunov o...@sai.msu.su:
On Wed, 3 Jun 2009, Tom Lane wrote:
Oleg Bartunov o...@sai.msu.su writes:
seems I don't understand how FOUND variable in pl/pgsql function defined,
when I use EXECUTE of PERFORM. There is no problem when I use plain SQL.
EXECUTE doesn't affect FOUND,
88 matches
Mail list logo