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, t
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 settings
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 re
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 assimi
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 a
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 incorrec
-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.
>
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 co
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 "s
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 mo
-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 PG
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 is
-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 durin
-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 thi
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 p
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 num_ini
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, modifi
-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 def
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.
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 h
-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
33 matches
Mail list logo
