-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
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
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.
-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
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
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
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, 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
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 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
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
-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
-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
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
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
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
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
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
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
> --- 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.
>
-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
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
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
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
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
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, '
',
"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
> 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
-
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)
> ***
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
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
Dear sir
how can get the log file in postgres sql
--
**
P.Maria Antony Thobiyas
Bosco InfoTech Pvt Ltd
Mobile: 09486144070 (Personal)
**
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
33 matches
Mail list logo
