Cody Pisto wrote:
I'm just looking for the correct workaround.
The canonically correct workaround it to define your own locale.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In versions below 8.0,
Dear sir
how can get the log file in postgres sql
--
**
P.Maria Antony Thobiyas
Bosco InfoTech Pvt Ltd
Mobile: 09486144070 (Personal)
**
We're moving from MySQL to PG, a move I am rather enjoying, but we're
currently running both databases. As we web-enable our financial
services in fifteen countries, I would like to recommend the team that
we move entirely to PG.
In doing research on big installations of the two databases, I read
Someone have a function that converts a string literal (a varchar
argument) to an integer array?
Thanks,
Gustavo.
PS: Please CC to me. I'm not subscribed at list.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
On 8/25/07, Thobiyas [EMAIL PROTECTED] wrote:
Dear sir
how can get the log file in postgres sql
--
**
P.Maria Antony Thobiyas
Bosco InfoTech Pvt Ltd
Mobile: 09486144070 (Personal)
**
would postgres convert data on the fly from UTF-8(storage) to ASCII for
sorting
That ain't possible, it seems, or else we wouldn't need UTF-8.
Karsten
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
Phoenix Kiula [EMAIL PROTECTED] wrote:
We're moving from MySQL to PG, a move I am rather enjoying, but we're
currently running both databases. As we web-enable our financial
services in fifteen countries, I would like to recommend the team that
we move entirely to PG.
In doing research on
Hi,
I think there might be a bug in the built in function pg_get_viewdef.
Basically if you have a function in your view SQL like this:
replace(address1, '\r', '')
pg_get_viewdef is returning the view definition with the \r replaced by
it's ASCII code which causes this:
replace(address1, '
Hi,
Someone mentioned we should put this in the PostgreSQL wiki.
Do you guys think that would be beneficial? If so, I don't mind the
work on the list I have done so far going on the wiki.
It would make it a lot easier to add other DBs to the mix.
Later,
Tony
---(end
Greg Smith wrote:
This is a really good comparision, focusing on features that I think
people understand rather than so much on technical trivia. Someone
else mentioned moving it onto the Wiki. Questions that pop into my head:
-Tony, would be you be comfortable with your work being
Bill Moran [EMAIL PROTECTED] writes:
First off, clustering is a word that is too vague to be useful, so
I'll stop using it.
Right. MySQL Cluster, on the other hand, is a very specific technology.
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster.html
It's interesting but far from an
Tony Caduto [EMAIL PROTECTED] writes:
Basically if you have a function in your view SQL like this:
replace(address1, '\r', '')
pg_get_viewdef is returning the view definition with the \r replaced by
it's ASCII code which causes this:
replace(address1, '
','')
This is not incorrect, if
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Benjamin Arai wrote:
This kind of disappointing, I was hoping there was more that could be done.
There has to be another way to do incremental indexing without loosing
that much performance.
What makes you think you are loosing performance by
--- Original Message ---
From: Tony Caduto [EMAIL PROTECTED]
To: Joshua D. Drake [EMAIL PROTECTED]
Sent: 25/08/07, 15:36:15
Subject: Re: [GENERAL] PostgreSQL vs Firebird feature comparison finished
Hi,
Someone mentioned we should put this in the PostgreSQL wiki.
Do you guys
Gustavo Tonini wrote:
Someone have a function that converts a string literal (a varchar
argument) to an integer array?
It isn't clear from your question if you want this:
select string_to_array('1,2,3'::varchar,',')::int[];
string_to_array
-
{1,2,3}
(1 row)
or this:
select
On Saturday 25 August 2007 01:40, Jaime Casanova wrote:
On 8/24/07, Robert Treat [EMAIL PROTECTED] wrote:
On Friday 24 August 2007 17:18, Matthew wrote:
Hey Bill,
It does not.
Bummer.
To get your columns in a specific order, specify the column names in
that
Hello!
I've just accidently stumbled upon
http://www.postgresql.org/docs/8.2/static/libpq-ldap.html
and thought hey, this is what my friend, a huge BigRDBMS fan, was
telling me about.
Now that I've read it, I think it could be very useful in an
enterpisish sort of way
(addressing databases as
Bill Moran wrote:
BTW: does anyone know of a link that describes these high-level concepts?
If not, I think I'll write this up formally and post it.
Chapter 24 -
http://www.postgresql.org/docs/8.2/interactive/high-availability.html
is a recent addition to the manual that starts to explain
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
As stated in the previous email if I use partitioning then queries
will be executed sequentially - i.e., instead of log(n) it would be
(# partitions) * log(n). Right?
Benjamin
On Aug 25, 2007, at 9:18 AM, Joshua D. Drake wrote:
-BEGIN
As stated in the previous email if I use partitioning then queries will
be executed sequentially - i.e., instead of log(n) it would be (#
partitions) * log(n). Right?
depends.. since indexes would be hit for each child table, the time for
query is dependent on the amount of data that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Benjamin Arai wrote:
As stated in the previous email if I use partitioning then queries will
be executed sequentially - i.e., instead of log(n) it would be (#
partitions) * log(n). Right?
The planner will consider every relevant partition during
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Since I am using tsearch2 on the table I think there is going to be a
significant performance hit - e.g., I partition by batch (batches are
not separated by date, they are essentially random subsets of a much
larger data-set). I am querying
On Aug 24, 2007, at 7:41 PM, Benjamin Arai wrote:
Hi,
I have an application which loads millions of NEW documents each month
into a PostgreSQL tsearch2 table. I have the initial version
completed
and searching performance is great but my problem is that each time
a new
month rolls around
On Aug 25, 2007, at 2:58 PM, Erik Jones wrote:
On Aug 24, 2007, at 7:41 PM, Benjamin Arai wrote:
Hi,
I have an application which loads millions of NEW documents each
month
into a PostgreSQL tsearch2 table. I have the initial version
completed
and searching performance is great but my
Hello.
I have a postgres 8.0 and ~400mb database with lots of simple selects
using indexes.
I've installed pgpool on the system. I've set num_init_children to 5 and
here is the top output.
One of postmasters is my demon running some insert/update tasks. I see
that they all use cpu heavily,
On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote:
Hello.
I have a postgres 8.0 and ~400mb database with lots of simple selects
using indexes.
I've installed pgpool on the system. I've set num_init_children to 5 and
here is the top output.
One of postmasters is my demon
On Sun, 26 Aug 2007 00:39:52 +0400, Martijn van Oosterhout
[EMAIL PROTECTED] wrote:
On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote:
Hello.
I have a postgres 8.0 and ~400mb database with lots of simple selects
using indexes.
I've installed pgpool on the system. I've set
On Sun, 26 Aug 2007 00:39:52 +0400, Martijn van Oosterhout
[EMAIL PROTECTED] wrote:
On Sun, Aug 26, 2007 at 01:22:58AM +0400, Max Zorloff wrote:
Hello.
shared_memory is used for caching. It is filled as stuff is used. If
you're not using all of it that means it isn't needed. Remember, it
Hi List;
I have a very large table (52million rows) - I'm creating a copy of it to rid
it of 35G worth of dead space, then I'll do a sync, drop the original table
and rename table2.
Once I have the table2 as a copy of table1 what's the best way to select all
rows that have been changed,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/25/07 21:51, Kevin Kempter wrote:
Hi List;
I have a very large table (52million rows) - I'm creating a copy of it to rid
it of 35G worth of dead space, then I'll do a sync, drop the original table
and rename table2.
What is your
On Saturday 25 August 2007 21:10:19 Ron Johnson wrote:
On 08/25/07 21:51, Kevin Kempter wrote:
Hi List;
I have a very large table (52million rows) - I'm creating a copy of it to
rid it of 35G worth of dead space, then I'll do a sync, drop the original
table and rename table2.
What is
Kevin Kempter wrote:
Hi List;
I have a very large table (52million rows) - I'm creating a copy of it to rid
it of 35G worth of dead space, then I'll do a sync, drop the original table
and rename table2.
Once I have the table2 as a copy of table1 what's the best way to select all
rows that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/25/07 22:21, Kevin Kempter wrote:
On Saturday 25 August 2007 21:10:19 Ron Johnson wrote:
On 08/25/07 21:51, Kevin Kempter wrote:
Hi List;
I have a very large table (52million rows) - I'm creating a copy of it to
rid it of 35G worth of dead
33 matches
Mail list logo
