> 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
On Tue, Sep 28, 2010 at 12:44 AM, Arjen Nienhuis 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 some special
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 re
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
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 ask */
> so
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 divid
On Mon, Sep 27, 2010 at 11:35 PM, Larry Leszczynski
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 looking for
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 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 the ideal candidate.
Yo
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 schema
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 http://www.sai.ms
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
> "novnovice" == novnovice 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 robust tha
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 cont
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 th
Brian Hirt 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
> public.pg_
Andy Colson 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 not have select ri
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?
On Tue, 28 Sep 2010 13:35 +0100, "Dave Page" 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:
>
> . That's a PITA. We build on Snow Leopard now, because we
> were g
On Tue, Sep 28, 2010 at 6:46 PM, Larry Leszczynski wrote:
>
> On Tue, 28 Sep 2010 13:35 +0100, "Dave Page" 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:
>>
>>
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 t
On Fri, Sep 24, 2010 at 3:22 PM, Tom Lane wrote:
> Eric McKeeth 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, expire_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
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.
> >
> > Tha
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 sug
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 w
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 Ubu
> -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
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: 2147483
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?
d
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: mit.
>
> 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_b
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 bec
Bruce Momjian 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 value larger
tha
It looks like it's related to atol
$ cat test-atol.c
#include
#include
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 = atoll("3000767169")
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
> #include
>
> int
> main(int argc, char **argv
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 s
On Tue, 28 Sep 2010 20:19:10 +0200
Alban Hertroys 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 (I can't check details right
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 did
Eddy Hahn 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
> would it skip it becau
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 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 UPDATE/DELETE
> > implement
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 upg
On Tue, Sep 28, 2010 at 4:07 PM, Jeff Davis 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 supports
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
http://www.enterprisedb.com/product
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 JOIN
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
u
On Wed, Sep 29, 2010 at 6:03 AM, David Fetter 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 plans for it? Ac
On Tue, Sep 28, 2010 at 9:11 PM, Itagaki Takahiro
wrote:
> On Wed, Sep 29, 2010 at 6:03 AM, David Fetter 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 s
On Wed, Sep 29, 2010 at 10:18 AM, Robert Haas 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 reviewing. We haven
Adam Wizon 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 restore and afte
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 | addr
On 9/28/2010 8:33 PM, Itagaki Takahiro wrote:
On Wed, Sep 29, 2010 at 10:18 AM, Robert Haas 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'
On Tue, Sep 28, 2010 at 9:33 PM, Itagaki Takahiro
wrote:
> On Wed, Sep 29, 2010 at 10:18 AM, Robert Haas 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
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(
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 (which
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 Srivast
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 an
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,
>
Hi,
Yes. Both matches with that specified in the Tools-> options in IE
(which is the same we used for configuring in stack builder).
Thanks & Regards,
Vishnu S
From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com]
Sent: Wednesday, September 29, 2010 11:04 AM
To: V
64 matches
Mail list logo