On Sun, 28 Mar 2010, Tom Lane wrote:
Faheem Mitha writes:
... In any case, feedback would be helpful. Details of my attempts
at optimization are at
http://bulldog.duhs.duke.edu/~faheem/snppy/opt.pdf
By and large, this is not the way to ask for help on the Postgres lists.
If you're supplyin
Hi,
I try to set the statement_timeout so that "select pg_stop_backup();"
will not hang if archive command failed. Below are the command and
errors.
psql.exe" -d mydb -h myhost -p 5432 -U postgres -w -c "set
statement_timeout = 1000; select pg_stop_backup();"
WARNING: pg_stop_backup still waitin
Tom,
Thanks for guidelines. I checked glibc versions. I am currently using
glibc libarary 2.3.3 on SUSE platform while build machine I used has
glibc library 2.5 . I will try to install it on SUSE machine with glibc
library 2.5.
Thanks & Regards,
Vikram
-Original Message-
From: Tom
"Vikram Patil" writes:
> Thanks for reply Tom. I am having source code form 8.4.1 version which
> is released on 09-09-2009.
> I was able to install it on Redhat machine without any issues. But I am
> facing this issue while running initdb on Suse Ent. 9 machine.( Linux
> 2.6.5-7.97-smp #1 SMP
Thanks for reply Tom. I am having source code form 8.4.1 version which
is released on 09-09-2009.
I was able to install it on Redhat machine without any issues. But I am
facing this issue while running initdb on Suse Ent. 9 machine.( Linux
2.6.5-7.97-smp #1 SMP Fri Jul 2 14:21:59 UTC 2004 i686 i
"Vikram Patil" writes:
> I am getting an floating exception while running initdb from custom
> built postgresql . I am using suse linux for installing postgresql.
> initDB.sh: line 14: 20285 Floating point exception$pgsql_home/bin/initdb
> -A password -U postgres --pwfile="pwFile" -E UTF8 -D
Hello Guys,
I am getting an floating exception while running initdb from custom
built postgresql . I am using suse linux for installing postgresql.
initDB.sh: line 14: 20285 Floating point exception$pgsql_home/bin/initdb
-A password -U postgres --pwfile="pwFile" -E UTF8 -D postgresql/data
> My question is, if one can get also index support for the '->' operator?
I am not sure what do you mean.
>>> SELECT id, (kvp->'a') FROM mytable;
>>>
>>> ... can be accelerated nevertheless by adding following where clause:
>>>
>>> SELECT id, (kvp->'a') FROM mytable WHERE kvp ? 'a';
>>>
>>> =>
Thank you Sergey for your reply.
I'm not sure how your partial index makes a difference. Obviously the
? operator gets indexed:
# EXPLAIN SELECT id, (kvp->'a') FROM mytable WHERE kvp ? 'a';
Index Scan using mytable_kvp_idx on mytable (cost=0.00..8.27 rows=1 width=36)
Index Cond: (kvp ? 'a'::te
Hi all,
When I try to import big file base.txt( 700MB),I get this:
x=# create table arquivo_serasa_marco( varchar(3000));
x=# COPY arquivo_serasa_marco from '/usr/local/pgsql/data/base.txt';
ERROR: literal newline found in data
HINT: Use "\n" to represent newline.
CONTEXT: COPY arquivo
Being asynchronous, means that write-to-disk will be queued in kernel for
later execution, ie, postgresql won't wait for its write confirmation, but
they will occurr in a serial manner.
On Thu, Mar 25, 2010 at 4:49 AM, Yan Cheng CHEOK wrote:
> I was wondering whether setting synchronous_commit
Kevin Kempter wrote:
I need a tool that will duplicate ALL messages from one db to another
(including begin, commit, etc). I think Playr does (did) this but the
myyearbook links from the past pg conference talks (the one from PG East 2009
in particular) no longer work.
After poking at the
Recently I ran a set of tests on two systems: a 4-core server with 5
disks (OS + WAL + 3 for DB) on a battery backed disk controller, and a
newer Hyper-threaded design with 4 physical cores turning into 8 virtual
ones--but only a single disk and no RAID controller, so I had to turn
off its wri
I will report back on this and attempt to give the particulars. It
will take 24 hours due to other time commitments.
Thank you very much for explaining :) this to me.
When I used only the first 10,000 rows of the 100+ thousand rows in
the original table (of two tables) I was working with,
Same result.
On Mon, Mar 29, 2010 at 1:51 PM, Raymond O'Donnell wrote:
> On 29/03/2010 18:38, Mark Vantzelfde wrote:
> > I am running 8.4 on a Windows Vista system. The software was installed
> using
> > the auto-install process. PostgreSQL starts successfully as a service
> when
> > the system
Hi Tom,
Thank you for the update
> This is much like the fact that, say, root can trivially destroy any
> Unix filesystem. You could imagine trying to put enough training wheels
> on superuserdom to prevent such things, but it's not really practical
> and any attempt would get in the way of man
On 29/03/2010 18:38, Mark Vantzelfde wrote:
> I am running 8.4 on a Windows Vista system. The software was installed using
> the auto-install process. PostgreSQL starts successfully as a service when
> the system boots. The running postgres* processes can be verified via Task
> Manager. I can run p
On Mon, Mar 29, 2010 at 11:00 AM, Steve Atkins wrote:
> For larger databases, IO speed is the bottleneck more often than not. In
> those cases throwing memory, better disk controllers and faster / more drives
> at them will improve things. More CPU will not.
We're in the situation where we are
I am running 8.4 on a Windows Vista system. The software was installed using
the auto-install process. PostgreSQL starts successfully as a service when
the system boots. The running postgres* processes can be verified via Task
Manager. I can run psql from the command prompt. I have the PGDATA env
v
In article <609bf3ce079445569fc0d047a5c81...@andrusnotebook>,
"Andrus" writes:
> Database column contains merge data in text column.
> Expressions are between << and >> separators.
> How to replace them with database values ?
> For example, code below should return:
> Hello Tom Lane!
> How to
Paul,
I have checked the different kinds of data in the table for their memory usage.
ST_LineSting is the one that's leaking, the other types complete
indexing without leakage.
Update to Geos 3.2.0 didn't improve the operation.
Kind regards
Frans
2010/3/28 Paul Ramsey :
> MIght be random, might
In response to Andreas Kretschmer :
> Bill Moran wrote:
>
> > > No, not really. But you can (and should) run EXPLAIN to
> > > obtain the execution plan for that query, und you can show us this plan
> > > (and the table-definition for all included tables). Maybe someone is able
> > > to tell you
On Mar 29, 2010, at 9:42 AM, Chris Barnes wrote:
>
> We have two camps that think that the speed of cpu processors is/aren't
> relative to the number of transactions that postgres that can performed per
> second.
>
> I am of the opinion that is we throw the faster processors at the database
On 29 March 2010 17:42, Thom Brown wrote:
> 2010/3/29 Andrus
>
> Database column contains large string without line feeds.
>> How to split it with word wrap between words ?
>> I tried to implement word wrap using
>>
>> create temp table test (line char(7));
>> insert into test select repeat('aa
Andrus wrote:
> Database column contains large string without line feeds.
> How to split it with word wrap between words ?
> I tried to implement word wrap using
>
> create temp table test (line char(7));
> insert into test select repeat('aa ',10);
> select * from test;
>
> Expected result is tha
2010/3/29 Andrus
> Database column contains large string without line feeds.
> How to split it with word wrap between words ?
> I tried to implement word wrap using
>
> create temp table test (line char(7));
> insert into test select repeat('aa ',10);
> select * from test;
>
> Expected result is
On Mar 28, 2010, at 7:45 PM, Yar Tykhiy wrote:
> On Fri, Mar 26, 2010 at 01:35:43PM -0500, Ogden wrote:
>> On Mar 26, 2010, at 1:32 PM, Greg Smith wrote:
>>
>>> Bryan Murphy wrote:
The one thing you should be aware of is that when you fail over, your
spare has no spares. I have not f
We have two camps that think that the speed of cpu processors is/aren't
relative to the number of transactions that postgres that can performed per
second.
I am of the opinion that is we throw the faster processors at the database
machine, there will be better performance.
Just like
Database column contains large string without line feeds.
How to split it with word wrap between words ?
I tried to implement word wrap using
create temp table test (line char(7));
insert into test select repeat('aa ',10);
select * from test;
Expected result is that table test contains multiple
Bill Moran wrote:
> > No, not really. But you can (and should) run EXPLAIN to
> > obtain the execution plan for that query, und you can show us this plan
> > (and the table-definition for all included tables). Maybe someone is able
> > to tell you what you can do to speed up your query.
>
> To
Boszormenyi Zoltan writes:
> I need to call a function via dblink that returns a void, i.e.
> technically nothing.
You're overthinking the problem. Imagine void is just a datatype
(which it is...) This should work:
select * from public.dblink('import', 'SELECT import.add_one_word(''word'',
tr
2010/3/29 Andrus :
>> oh sorry, you are asked on 8.1 on yesterday
>
> I'm developing in 8.4 but customers have servers starting at 8.1
> So I asked for a solution starting at 8.1 Hopefully renaming unnest to
> something other will work in all servers.
>
ok. It is better to describe your environmen
On 29/03/2010 15:43, 赤松 建司 wrote:
> help
Surely. What with? :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
In response to "A. Kretschmer" :
> In response to John Gage :
> > I ran a query out of pgAdmin, and (as I expected) it took a long
> > time. In fact, I did not let it finish. I stopped it after a little
> > over an hour.
> >
> > I'm using 8.4.2 on a Mac with a 2.4GHz processor and 2GB of RA
In response to John Gage :
> I ran a query out of pgAdmin, and (as I expected) it took a long
> time. In fact, I did not let it finish. I stopped it after a little
> over an hour.
>
> I'm using 8.4.2 on a Mac with a 2.4GHz processor and 2GB of RAM.
>
> My question is: is there a way to tell
oh sorry, you are asked on 8.1 on yesterday
I'm developing in 8.4 but customers have servers starting at 8.1
So I asked for a solution starting at 8.1
Hopefully renaming unnest to something other will work in all servers.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgres
On Mon, Mar 29, 2010 at 02:08:23PM +, Edgardo Portal wrote:
> On 2010-03-29, Juan Backson wrote:
> > --0016e64ccb10fb54050482f07924
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > Hi,
> >
> > I am using Postgres to store CDR data for voip switches. The data
> > size quickly goes abou
2010/3/29 Andrus :
>> If renaming the function makes it appear to work differently,
>> then there is another function of similar name in there somewhere.
>> I'm betting the server is not 8.1 after all.
>
> I'm using
>
> "PostgreSQL 8.4.1, compiled by Visual C++ build 1400, 32-bit"
>
oh sorry, you
bye
end
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I need to call a function via dblink that returns a void, i.e.
technically nothing.
=# select public.dblink_exec('import', 'SELECT
import.add_one_word(''word'', true)');
ERROR: statement returning results not allowed
=# select * from public.dblink('import', 'SELECT
import.add_one_word(''wor
If renaming the function makes it appear to work differently,
then there is another function of similar name in there somewhere.
I'm betting the server is not 8.1 after all.
I'm using
"PostgreSQL 8.4.1, compiled by Visual C++ build 1400, 32-bit"
Andrus.
--
Sent via pgsql-general mailing list
help
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I ran a query out of pgAdmin, and (as I expected) it took a long
time. In fact, I did not let it finish. I stopped it after a little
over an hour.
I'm using 8.4.2 on a Mac with a 2.4GHz processor and 2GB of RAM.
My question is: is there a way to tell how close the query is to being
finis
Pavel Stehule writes:
> 2010/3/29 Tom Lane :
>> I think if it appeared to work before it was because the built-in
>> unnest() function was capturing the call.
> he uses 8.1. the bug is in "generate_series(1,>>>4<<<)"
If renaming the function makes it appear to work differently,
then there is ano
Thanks Dim; I was not aware of pgloader. This, and the other suggestions,
have helped a lot; thanks everyone.
--rick
On Mon, Mar 29, 2010 at 7:41 AM, Dimitri Fontaine wrote:
> Rick Casey writes:
>
> > So, I am wondering if there is any to optimize this process? I have been
> using Postgres for
On 2010-03-29, Juan Backson wrote:
> --0016e64ccb10fb54050482f07924
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
>
> I am using Postgres to store CDR data for voip switches. The data size
> quickly goes about a few TBs.
>
> What I would like to do is to be able to regularly archive the
2010/3/29 Andrus :
> This returns 5 rows:
>
> CREATE OR REPLACE FUNCTION unnest(anyarray)
> RETURNS SETOF anyelement as $$
> SELECT $1[i] FROM generate_series(1,4) g(i) <<--- 4 is constant
> $$ LANGUAGE sql;
>
> select unnest(string_to_array('23,2,3,4,5',','));
>
> simply changing nam
"Andrus" writes:
> I changed unction name and tried:
> CREATE OR REPLACE FUNCTION unnest21(anyarray)
> RETURNS SETOF anyelement as $$
> SELECT $1[i] FROM generate_series(1,4) g(i)
> $$ LANGUAGE sql;
> select unnest21(string_to_array('23,2,3,4,5',','));
> In this case it returns only 4 rows.
>
2010/3/29 Tom Lane :
> "Andrus" writes:
>> I changed unction name and tried:
>> CREATE OR REPLACE FUNCTION unnest21(anyarray)
>> RETURNS SETOF anyelement as $$
>> SELECT $1[i] FROM generate_series(1,4) g(i)
>> $$ LANGUAGE sql;
>
>> select unnest21(string_to_array('23,2,3,4,5',','));
>
>> In this
2010/3/29 Andrus :
> Pavel
>
> thank you.
> How to add word wrap to this at some column between words ?
> For example string
> ' '
>
> if word wrap is at column 12 should produce table with two rows:
>
>
>
>
You can't do it. This working only for one column.
This returns 5 rows:
CREATE OR REPLACE FUNCTION unnest(anyarray)
RETURNS SETOF anyelement as $$
SELECT $1[i] FROM generate_series(1,4) g(i)
$$ LANGUAGE sql;
select unnest(string_to_array('23,2,3,4,5',','));
simply changing name returns 4 rows:
CREATE OR REPLACE FUNCTION unnest21(anyarray)
RET
On Monday 29. March 2010 16.51.35 Ole Tange wrote:
> I have 2 tables that have the same column names but in different
> order. Similar to this:
>
> create table test_a (col_a text, col_b int);
> create table test_b (col_b int, col_a text);
> insert into test_a values ('abc', 2),( 'def', 3);
I changed unction name and tried:
CREATE OR REPLACE FUNCTION unnest21(anyarray)
RETURNS SETOF anyelement as $$
SELECT $1[i] FROM generate_series(1,4) g(i)
$$ LANGUAGE sql;
select unnest21(string_to_array('23,2,3,4,5',','));
In this case it returns only 4 rows.
No idea what is happening.
Andru
Pavel
thank you.
How to add word wrap to this at some column between words ?
For example string
' '
if word wrap is at column 12 should produce table with two rows:
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
"Andrus" writes:
> Pavel,
>> pa...@postgres:5481=# select unnest(string_to_array('23,2,3,4,5',','));
>> unnest
>>
>> 23
>> 2
>> 3
>> 4
>> (4 rows)
> Result is wrong: it must contain 5 rows.
Surely that's a copy-and-paste mistake? I get 5 rows from this example.
raghavendra t writes:
> How to give security to the pg_catalogs, as these are freely alterable and
> cause some security problem. Here i mean to say, as a superuser we can
> delete the rows from a catalogs are alter the catalogs, is there anyway to
> put restriction or any promting before doing an
I have 2 tables that have the same column names but in different
order. Similar to this:
create table test_a (col_a text, col_b int);
create table test_b (col_b int, col_a text);
insert into test_a values ('abc', 2),( 'def', 3);
I would like to do this:
insert into test_b (select * from
Rick Casey writes:
> So, I am wondering if there is any to optimize this process? I have been
> using Postgres for several years, but have never had to partition or optimize
> it for files
> of this size until now.
> Any comments or suggestions would be most welcomed from this excellent forum.
2010/3/29 Andrus :
> Pavel,
>
>> CREATE OR REPLACE FUNCTION unnest(anyarray)
>> RETURNS SETOF anyelement as $$
>> SELECT $1[i] FROM generate_series(1,4) g(i)
>> $$ LANGUAGE sql;
>>
>> pa...@postgres:5481=# select unnest(string_to_array('23,2,3,4,5',','));
>> unnest
>>
>> 23
>> 2
>> 3
>> 4
Pavel,
CREATE OR REPLACE FUNCTION unnest(anyarray)
RETURNS SETOF anyelement as $$
SELECT $1[i] FROM generate_series(1,4) g(i)
$$ LANGUAGE sql;
pa...@postgres:5481=# select unnest(string_to_array('23,2,3,4,5',','));
unnest
23
2
3
4
(4 rows)
Result is wrong: it must contain 5 rows.
Ho
On 29 Mar 2010, at 14:33, Clemens Eisserer wrote:
> Hi,
>
> Sorry for beeing a bit off-topic.
> Recently I've done some database-fontends, which I used
> java+swingset+netbeans-gui-builder for.
> Compared to plain java development is quite fast - however I wonder
> wether you could recommend db-
Hi
Instead of dropping the table, I would like to archive the old table into a
format that can be read and retrieved.
Can I db_dump on each child table?
What is the best way to do it? db_dump and make the data into csv and then
tar.gz it or backup it up into a pg archived format?
thanks,
jb
O
In response to Juan Backson :
> Hi,
>
> I am using Postgres to store CDR data for voip switches. The data size
> quickly
> goes about a few TBs.
>
> What I would like to do is to be able to regularly archive the oldest data so
> only the most recent 6 months of data is available.
>
> All t
Hi,
I am using Postgres to store CDR data for voip switches. The data size
quickly goes about a few TBs.
What I would like to do is to be able to regularly archive the oldest data
so only the most recent 6 months of data is available.
All those old data will be stored in a format that can be re
2010/3/29 Andrus :
>> no it is in same order. generate_series generates indexes from
>
> 1,2,3 so result have to be exactly in same order. You do some
> wrong.
>
> In my sample I used joind and projecton this changes order.
> How to add order number 1,2,.. to created table ?
>
you cannot use j
Hi All,
How to give security to the pg_catalogs, as these are freely alterable and
cause some security problem. Here i mean to say, as a superuser we can
delete the rows from a catalogs are alter the catalogs, is there anyway to
put restriction or any promting before doing anything to catalogs.
An
no it is in same order. generate_series generates indexes from
1,2,3 so result have to be exactly in same order. You do some
wrong.
In my sample I used joind and projecton this changes order.
How to add order number 1,2,.. to created table ?
Andrus.
--
Sent via pgsql-general mailing list (
On 29 March 2010 02:57, Stefan Keller wrote:
> Documentation at "F.13.3. Indexes" says that "hstore has index support
> for @> and ? operators..."
> => Therefore no index does support equality-indexes?
>
> If so, then I suppose that following (potentially slow) query
> which contains an equality t
On 2010-03-29, Armand Turpel wrote:
> Hi,
>
> Updating an array field with one null value isnt possible:
>
> UPDATE table SET integer_array = ARRAY[NULL]
>
Try to specify an explicit type, e.g. ARRAY[NULL]::int[]
> But those queries are working:
>
> UPDATE table SET integer_array = ARRAY[NU
Hi,
Updating an array field with one null value isnt possible:
UPDATE table SET integer_array = ARRAY[NULL]
But those queries are working:
UPDATE table SET integer_array = ARRAY[NULL,1]
UPDATE table SET integer_array = ARRAY[1,NULL]
This dosent seems logical to me.
Is it a bug?
Thanks for he
If you are sure that your words are space delimited, you may use this:
select regexp_replace('Ispahani Public School'||' ', '([^ ])([^ ]* )',
'\\1', 'g');
Regards,
Ognjen
Timo Klecker wrote:
Try this:
SELECT regexp_matches('foobar beque bazil barf bonk', '(\\m.)', 'g')
Now you have the fi
Try this:
SELECT regexp_matches('foobar beque bazil barf bonk', '(\\m.)', 'g')
Now you have the first letters, you can use array_to_string to get an string
and use concat_str after this:
http://stackoverflow.com/questions/43870/how-to-concatenate-strings-of-a-str
ing-field-in-a-postgresql-
and what abourt that :
http://www.postgresql.org/docs/8.4/interactive/functions-string.html
Le lundi 29 mars 2010 à 14:44 +0600, AI Rumman a écrit :
> I need a query to get the initial letter of the words:
> Like:
>
> Ispahani Public School IPS
> Ahmed Iftekhar AI
>
> Any
I need a query to get the initial letter of the words:
Like:
Ispahani Public School IPS
Ahmed Iftekhar AI
Any help please.
Hi,
Sorry for beeing a bit off-topic.
Recently I've done some database-fontends, which I used
java+swingset+netbeans-gui-builder for.
Compared to plain java development is quite fast - however I wonder
wether you could recommend db-fontend generators like the infamous
access.
What I've found so f
On 29 Mar 2010, at 6:03, Tadipathri Raghu wrote:
> Hi Alban,
>
> Thank you for the update.
>
> For one thing: The table holds information regarding to which transactions
> each row is visible (the xid) whereas the index does not.
>
> What would be the each value of the xid, like 8 bytes,or
Paul,
took your advice and installed Geos 3.2.0.
Index is now running for 14 hrs, postmaster is taking all the RAM.
Sadly it looks like the Geos update didn't save me.
Regards
Frans
2010/3/28 Paul Ramsey :
> GEOS 3.2 is backwards compatible, so you can install it overtop of 3.1
> and things will
On 2010-03-29, David Kerr wrote:
> On 3/27/2010 12:46 AM, John R Pierce wrote:
>> Allan Kamau wrote:
>>> You may also have a look at Commons DBCP from Apache software
>>> foundation, "http://commons.apache.org/dbcp/";. I have used it for a
>>> few projects and have had no problems.
>>
>> for tha
78 matches
Mail list logo
