That's a surprising response. But it makes sense, at least as one
perspective. I have written light duty sync systems but figured that there
would be some battle tested postgresql solution that was more robust than I
could cobble together. As in, if I invest 40 hours learning replication
system
On 28/09/10 11:25, Tim Uckun wrote:
On Tue, Sep 28, 2010 at 3:39 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Tim Uckun timuc...@gmail.com writes:
Is there a way to tell postgres to stop any query that runs longer
than a specified amount of time? Say an hour?
Setting statement_timeout would do
I migrated data from Postgresql 8.1 to Postgresql 8.4 using pg_dump.
But now I found that, most of the queries in my applicaiton are being
failed. Invesitigating the problem, I found that no function is available in
the DB to CAST INT to TEXT etc.
Most of the queries are failed because implicit
On 28 September 2010 07:37, AI Rumman rumman...@gmail.com wrote:
I migrated data from Postgresql 8.1 to Postgresql 8.4 using pg_dump.
But now I found that, most of the queries in my applicaiton are being
failed. Invesitigating the problem, I found that no function is available in
the DB to
Hello
see
http://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql.html
Regards
Pavel Stehule
2010/9/28 AI Rumman rumman...@gmail.com:
I migrated data from Postgresql 8.1 to Postgresql 8.4 using pg_dump.
But now I found that, most of the queries in my applicaiton
On 09/27/10 11:18 PM, novnovice wrote:
That's a surprising response. But it makes sense, at least as one
perspective. I have written light duty sync systems but figured that there
would be some battle tested postgresql solution that was more robust than I
could cobble together. As in, if I
4) Do a SELECT on each row that starts with MikeChristensen and then
trying to append the row count to the end, this might not be exact but
it's somewhat intelligent as a starting point. However, this might
require some special indexes on this table to quickly scan rows that
start with a
On Tue, Sep 28, 2010 at 12:44 AM, Arjen Nienhuis a.g.nienh...@gmail.com wrote:
4) Do a SELECT on each row that starts with MikeChristensen and then
trying to append the row count to the end, this might not be exact but
it's somewhat intelligent as a starting point. However, this might
require
Hello All,
Need some help in scaling PostgreSQL:
I have a table with 400M records with 5 int columns having index only on 1
column.
Rows are updated by a perl script which takes 10k numbers in one transactions
and fires single single update in a loop on database keeping track of the
result
I know I'm comparing apples and orange but still the difference in
performance was quite astonishing.
I've 2 tables that look like:
create table products(
id bigint
price double precision, /* legacy, don't ask */
sometextfield1 varchar(128),
sometextfield2 varchar(128),
...
);
one on
On Tue, Sep 28, 2010 at 1:49 PM, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
I know I'm comparing apples and orange but still the difference in
performance was quite astonishing.
I've 2 tables that look like:
create table products(
id bigint
price double precision, /* legacy, don't
On Tue, Sep 28, 2010 at 6:31 AM, sandeep prakash dhumale
sandy9...@rediffmail.com wrote:
I have a table with 400M records with 5 int columns having index only on 1
column.
How is your data used? Is the update done by the primary key? Are the
queries segmented in some way that may divide
On Mon, Sep 27, 2010 at 11:35 PM, Larry Leszczynski
lar...@emailplus.org wrote:
Hi -
I use Dave Page's one-click installers for Mac OS X:
http://www.enterprisedb.com/products/pgdownload.do#osx
I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will
not load because it is
On Tue, 28 Sep 2010 17:45:16 +0530 wrote
On Tue, Sep 28, 2010 at 6:31 AM, sandeep prakash dhumale wrote:
I have a table with 400M records with 5 int columns having index only on 1
column.
How is your data used? Is the update done by the primary key? Are the queries
segmented in some way
On Tue, Sep 28, 2010 at 8:56 AM, Sandy sandy9...@rediffmail.com wrote:
Table has mobile number,status and expiry date. I can not partition on
expiry date as all SELECT's are on mobile number.
Then partition on the mobile number. If your updates and queries are all
tied to that, then it is
On Tue, Sep 28, 2010 at 12:37:46PM +0600, AI Rumman wrote:
I migrated data from Postgresql 8.1 to Postgresql 8.4 using
pg_dump. But now I found that, most of the queries in my
applicaiton are being failed. Invesitigating the problem, I found
that no function is available in the DB to CAST
Hello group,
is there a functionality like 'create or REPLACE table/view'
to circumvent drop with 'cascade' and recreation of depending objects?
I have a table schema1.x (col1, col2)
and a view schema1.v - schema1.x(col1)
Another table is schema2.x(col1, col2) with same structure as x in
I firstly tried to solve the problem deleting the second parameter from all
the calls to the stringToQualifiedNameList function, I wouldn't expect it,
but it worked out, of course it was not the most elegant way.
Oleg Bartunov wrote:
Get gevel from cvs, address is on
On Mon, 2010-09-27 at 20:08 -0700, novnovice wrote:
Can anyone recommend a relatively simple merge replication package that would
work well on windows and which relies on one of the current postgresql
versions? 9 would be fine for my needs. I'm a fairly unsophisticated
postgresql user; and not
novnovice == novnovice novnov...@gmail.com writes:
novnovice That's a surprising response. But it makes sense, at least as
novnovice one perspective. I have written light duty sync systems but
novnovice figured that there would be some battle tested postgresql
novnovice solution that was more
Joshua, you're with command prompt...you had/have a product called mammoth
replicator which I looked at. It seemed approx what I was after but the
project didn't seem very alive. Was my use case not what mammoth was about?
Or is it just that mammoth is basically gone?
--
View this message in
On Tue, 2010-09-28 at 09:32 -0700, novnovice wrote:
Joshua, you're with command prompt...you had/have a product called mammoth
replicator which I looked at. It seemed approx what I was after but the
project didn't seem very alive. Was my use case not what mammoth was about?
Or is it just that
Brian Hirt bh...@me.com writes:
I'm testing pg_upgrade out and ran into a couple of problems. First when I
did pg_upgrade --check I got the tsearch2 tables preventing the upgrade from
happening:
Database: testdatabase
public.pg_ts_dict.dict_init
public.pg_ts_dict.dict_lexize
Andy Colson a...@squeakycode.net writes:
Having a little problem with my large objects. In 8.4 the db owner was
'andy', but my web connected as payuser (which had appropriate permissions).
The backup/restore to pg9 made all the large objects owned by 'andy',
and I'm guessing payuser does
Ian Barwick wrote:
Well, that is step #4:
? ? ? http://www.postgresql.org/docs/9.0/static/pgupgrade.html
? ? ? 4.
? ? ? Install pg_upgrade
? ? ? Install pg_upgrade and pg_upgrade_support in the new PostgreSQL
cluster
Was that not clear enough?
I hope my comment didn't
On Tue, 28 Sep 2010 13:35 +0100, Dave Page dp...@pgadmin.org wrote:
I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will
not load because it is looking for Perl 5.10 in the System dirs and I
only have 5.8.8:
grumble. That's a PITA. We build on Snow Leopard now,
On Tue, Sep 28, 2010 at 6:46 PM, Larry Leszczynski lar...@emailplus.org wrote:
On Tue, 28 Sep 2010 13:35 +0100, Dave Page dp...@pgadmin.org wrote:
I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will
not load because it is looking for Perl 5.10 in the System dirs and I
On 28 Sep 2010, at 1:41, Tim Uckun wrote:
Sometimes some queries get stuck in that they run for hours and
hours. They never stop running. Killing the deamon does not stop the
query from running.
You really should try to find out why they get stuck. Killing stuck clients
isn't going to
On Fri, Sep 24, 2010 at 3:22 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Eric McKeeth eldi...@gmail.com writes:
why would I get the following error, since the period() function is in
fact
declared as immutable?
test=# ALTER TABLE test3 ADD exclude using
gist(period(effect_date::timestamptz,
On 28 Sep 2010, at 12:49, Ivan Sergio Borgonovo wrote:
The hardware on the 2 machines is a bit different.
MS SQL 2005 runs on a box that is 2 years old, 2 SATA drives on RAID
1 hw, 2 Xeon dual core (I can't check details right now)
PG runs on a box that has more than 5 years, 3 SCSI drives on
Hi Dave -
you could try building the 64 bit binary:
CFLAGS=-isysroot /Developer/SDKs/MacOSX10.5.sdk
-mmacosx-version-min=10.5 -O2 -arch x86_64 ./configure
Excellent! Looks like that worked fine. I just added the --with-perl
option to configure.
Thanks Dave!
You're
On Mon, Sep 27, 2010 at 06:36:25PM -0700, Mike Christensen wrote:
Thus, the users table already has:
MikeChristensen1
MikeChristensen2
MikeChristensen3
MikeChristensen4
I want to write a SQL query that figures out that MikeChristensen5 is
the next available username and thus suggest it.
On Sep 28, 2010, at 11:50 AM, Dave Page wrote:
You're welcome. I guess it is running the 64bit image - is your
machine Leopard Server?
That's irrelevant. The 32-bit vs 64-bit default is for the kernel and
extensions, not for applications. On 64-bit hardware, apps can be run as
64-bit, and
On Tue, Sep 28, 2010 at 02:35:09PM +0300, Allan Kamau wrote:
I have access
to a server running PG 8.4 on Ubuntu and I have noticed that after a
day of intense use the PG slows down significantly, free -g reports
almost no free memory available (something seems to leak memory on
this Ubuntu
-Original Message-
From: sandeep prakash dhumale [mailto:sandy9...@rediffmail.com]
Sent: Tuesday, September 28, 2010 6:32 AM
To: pgsql-general@postgresql.org
Subject: Scaling PostgreSQL-9
Hello All,
Need some help in scaling PostgreSQL:
I have a table with 400M records
Looks like pg_upgrade is using 32bit oids. 2147483647 is the max signed 32 bit
int, but the oids for my tables are clearly larger than that.
== output from pg_upgrade ==
Database: basement84_dev
relname: mit.company: reloid: 2147483647 reltblspace:
relname: mit.company_history: reloid:
I am using 8.4.2 on centos 5.4 2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT
2009 x86_64 x86_64 x86_64 GNU/Linux
I have autovacuum processes that appear to have been running most of the day.
There aren't any messages in the log, but there must be something wrong for it
to take this long?
Brian Hirt wrote:
Looks like pg_upgrade is using 32bit oids. 2147483647 is the max signed 32
bit int, but the oids for my tables are clearly larger than that.
== output from pg_upgrade ==
Database: basement84_dev
relname: mit.company: reloid: 2147483647 reltblspace:
relname:
You really should try to find out why they get stuck. Killing stuck clients
isn't going to solve your problem (aside from the fact that you probably
shouldn't be using kill -9 on them, that's like using a jackhammer on a
jammed door).
Well I didn't use kill -9 I used the pg_cancel_backend
Hi,
I would like to suggest to enhance the documentation of the CREATE VIEW
statement.
I think the fact that a SELECT * is internally stored as the expanded column
list (valid at the time when the view was created) should be documented together with the
CREATE VIEW statement. Especially
Bruce Momjian br...@momjian.us writes:
Interesting. Odd it would report the max 32-bit signed int. I wonder
if it somehow is getting set to -1. I looked briefly at the pg_upgrade
code and it appears to put all oids in unsigned ints.
On some platforms, that's what you'll get if you feed a
It looks like it's related to atol
$ cat test-atol.c
#include stdlib.h
#include stdio.h
int
main(int argc, char **argv)
{
unsigned int test1;
long test2;
long long test3;
unsigned int test4;
test1 = (unsigned int)atol(3000767169);
test2 = (long)atol(3000767169);
test3 =
Brian Hirt wrote:
It looks like it's related to atol
Yep, I found the use of atol in the pg_upgrade code too. Working on a
patch now.
---
$ cat test-atol.c
#include stdlib.h
#include stdio.h
int
main(int argc,
Folks,
We're almost half way through the commitfest, and so I'll start with:
The Good:
- Most patches still in play have a reviewer.
- It's possible for one person to post 5 reviews in a day. Robert
Haas actually did this on his own time yesterday.
- New people have been reviewing patches,
Hi,
1) I'm reading the API documentation and I'm wondering how the client library
would handle the following statement
INSERT INTO test (value1, value2) VALUES ('$1', $1)
Would it handle it incorrectly and would think that '$1' is the parameter or
would it skip it because it know that it's a
On Tue, 28 Sep 2010 20:19:10 +0200
Alban Hertroys dal...@solfertje.student.utwente.nl wrote:
On 28 Sep 2010, at 12:49, Ivan Sergio Borgonovo wrote:
The hardware on the 2 machines is a bit different.
MS SQL 2005 runs on a box that is 2 years old, 2 SATA drives on
RAID 1 hw, 2 Xeon dual core
Bruce Momjian wrote:
Brian Hirt wrote:
It looks like it's related to atol
Yep, I found the use of atol in the pg_upgrade code too. Working on a
patch now.
I have applied the attached patch to HEAD and 9.0.X. Odd I had never
received a bug report about this before. Good thing it didn't
Eddy Hahn ed...@creightonedward.com writes:
1) I'm reading the API documentation and I'm wondering how the client library
would handle the following statement
INSERT INTO test (value1, value2) VALUES ('$1', $1)
Would it handle it incorrectly and would think that '$1' is the parameter or
On Tue, 2010-09-28 at 12:18 -0600, Eric McKeeth wrote:
This is ugly, but it does seem to enforce the constraint I need, of
non-overlapping dates where sharing an endpoint is not considered an
overlap.
The period type supports different inclusivity/exclusivity combinations.
So, the period:
On Sat, 25 Sep 2010 12:32:55 +0200
Alban Hertroys dal...@solfertje.student.utwente.nl wrote:
On 24 Sep 2010, at 21:20, Bartłomiej Korupczyński wrote:
Hi guys,
I've found some posts from 2007 about UPDATE/DELETE ... LIMIT N syntax
and I'd like to raise it again. Current PostgreSQL of
Hi,
I'm curious how do you handle results from multiple tables with
repeated column names. For example:
# CREATE TABLE c1 (id integer PRIMARY KEY, address inet);
# CREATE TABLE c2 (id integer PRIMARY KEY, address text);
# SELECT * FROM c1 JOIN c2 USING (id);
id | address | address
Bruce,
The applied patch has the same behavior on i686 Ubuntu 10.04. It looks like
atol() is just a macro for strtol() in stdio.h. I think you want strtoul()
instead of strtol()
when i change str2uint() to use strtoul() pg_upgrade completes without a
problem (I still haven't tested the
On Tue, Sep 28, 2010 at 4:07 PM, Jeff Davis pg...@j-davis.com wrote:
On Tue, 2010-09-28 at 12:18 -0600, Eric McKeeth wrote:
This is ugly, but it does seem to enforce the constraint I need, of
non-overlapping dates where sharing an endpoint is not considered an
overlap.
The period type
I cannot install PostgreSQL 9.0 (x86-64) under Windows 7 (x86-64). The
installer fails right after starting the installation process with the
message:
An error occurred executing the Microsoft VC++ runtime installer.
I am using the installer from EnterpriseDB
On 28/09/2010 23:53, Bartlomiej Korupczynski wrote:
Hi,
I'm curious how do you handle results from multiple tables with
repeated column names. For example:
# CREATE TABLE c1 (id integer PRIMARY KEY, address inet);
# CREATE TABLE c2 (id integer PRIMARY KEY, address text);
# SELECT * FROM c1
I installed v9.0 on my Mac Pro. Dumped the 8.4 database using 'pg_dump -Fc -d
dbname --username=xyz backup_file_name' using the pg_dump from the 8.4
installation. I restored the database using 'pg_restore -d dbname
backup_file_name' using the 9.0 restore and after creating a new database
On Wed, Sep 29, 2010 at 6:03 AM, David Fetter da...@fetter.org wrote:
The Good:
- Most patches still in play have a reviewer.
As far as I remember, there were discussions about the issue
A patch has a reviewer, but in Needs Review state for several weeks
in 9.0 development.
Do we have any
On Tue, Sep 28, 2010 at 9:11 PM, Itagaki Takahiro
itagaki.takah...@gmail.com wrote:
On Wed, Sep 29, 2010 at 6:03 AM, David Fetter da...@fetter.org wrote:
The Good:
- Most patches still in play have a reviewer.
As far as I remember, there were discussions about the issue
A patch has a
On Wed, Sep 29, 2010 at 10:18 AM, Robert Haas robertmh...@gmail.com wrote:
No, the column is very clearly labelled Reviewers, not Reviewer.
And we have certainly had patches with more than one person's name in
that field in the past. The issue is rather that we don't have enough
people
Adam Wizon adamwi...@mac.com writes:
I installed v9.0 on my Mac Pro. Dumped the 8.4 database using 'pg_dump -Fc
-d dbname --username=xyz backup_file_name' using the pg_dump from the 8.4
installation. I restored the database using 'pg_restore -d dbname
backup_file_name' using the 9.0
Bartlomiej Korupczynski wrote:
I'm curious how do you handle results from multiple tables with
repeated column names. For example:
# CREATE TABLE c1 (id integer PRIMARY KEY, address inet);
# CREATE TABLE c2 (id integer PRIMARY KEY, address text);
# SELECT * FROM c1 JOIN c2 USING (id);
id |
On 9/28/2010 8:33 PM, Itagaki Takahiro wrote:
On Wed, Sep 29, 2010 at 10:18 AM, Robert Haasrobertmh...@gmail.com wrote:
No, the column is very clearly labelled Reviewers, not Reviewer.
And we have certainly had patches with more than one person's name in
that field in the past. The issue is
On Tue, Sep 28, 2010 at 9:33 PM, Itagaki Takahiro
itagaki.takah...@gmail.com wrote:
On Wed, Sep 29, 2010 at 10:18 AM, Robert Haas robertmh...@gmail.com wrote:
No, the column is very clearly labelled Reviewers, not Reviewer.
And we have certainly had patches with more than one person's name in
Darren Duncan wrote:
3. Suggestion, but it would be probably hard to implement: to make SQL
engine prefix each returned column with table alias. Of course it would
not be a default behavior, but it would be enabled by some session wide
setting.
# SELECT * FROM c1, c2 WHERE c1.id=c2.id;
c1.id |
Brian Hirt wrote:
Bruce,
The applied patch has the same behavior on i686 Ubuntu 10.04. It
looks like atol() is just a macro for strtol() in stdio.h. I think
you want strtoul() instead of strtol()
Yes, thanks. I have now applied that fix in HEAD and 9.0.X.
when i change str2uint() to
Thanks for the fast reply. I must have still been connected to the older
database somehow. I cleaned up my installation and restored the database. No
error messages this time. I need to change the pg_hba.conf file. I read the
documentation and its supposed to be in the data directory
Hi,
Yes, using some proxy. The XML file mentioned in the URL can be opened
in browser. Even after setting the proxy values mentioned in the IE
(Tools-Internet Options -Connections-LAN settings), the same message
box is shown.
Thanks Regards,
Vishnu S
From: Sachin Srivastava
Hi List
I have a largish partitioned table, it has ~60 million records in each
of 12 partitions. It appears that a Full Text Index could speed up some
user queries a lot.
A quick test with an additional tsvector column revealed that this would
take up around 35 GB of space for this column
What are the values of:
HKEY_CURRENT_USER\Software\PostgreSQL\StackBuilder\HTTP Proxy Host and
HKEY_CURRENT_USER\Software\PostgreSQL\StackBuilder\HTTP Proxy Port ?
Can you make sure whether both of them matches with the correct values?
On Sep 29, 2010, at 10:27 AM, Vishnu S. wrote:
Hi,
69 matches
Mail list logo