Final specs for the server is just an ordinary desktop fitted w/ 3
7200rpm 500GB drives & 1 7200 80GB drive / 1 GB ram / 2G processor
(single core)
number of records will be between 3 to 30 million rows.
Currently the process is
1. pull from mssql
2. \copy into PG temp table
3. insert into fina
On 9/18/07, Bill Moseley <[EMAIL PROTECTED]> wrote:
> I'm just starting with pgcrypto, and I'm curious if it's
> needed/recommended to use an initialization vector/value (IV) with
> the pgp_sym_encrypt() function.
>
> The docs hint that an IV is used automatically, but encrypting plain
> text that
2007/9/18, Ow Mun Heng <[EMAIL PROTECTED]>:
> Hi,
>
> I have 3 tables
>
> foo
> foo_loading_source1
> foo_loading_source2
>
> which is something like
>
> create table foo (a int, b int, c int)
> create table foo_loading_source1 (a int, b int, c int)
> create table foo_loading_source2 (a int, b int,
On 9/17/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > > CREATE OR REPLACE FUNCTION foo_func(fromdate timestamp, todate
> > > timestamp, code text)
> > > LANGUAGE 'sql' IMMUTABLE STRICT;
> > But If I were to use ALIASINg, I get an error
> >
> > eg: DECLARE
> > DECLARE
> > fromdate ALIAS fo
2007/9/18, Joshua D. Drake <[EMAIL PROTECTED]>:
> If you overrun your max_fsm_pages then vacuum analyze IS NOT ENOUGH. If
> you do not overrun your max_fsm_pages, yes vacuum analyze can deal with
> the issue.
Are you sure? I have a situation where above is no true. postgres
version 8.1.8. while v
On Tue, 2007-09-18 at 06:01 -0400, Bill Moran wrote:
> * (with newer version) reduce the fill factor and REINDEX
What is fill factor?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Hi,
I'm running a PostgreSQL 8.1.9 server on Debian etch (default installation,
w/ PostGIS from Debian repositories).
The machine has double Xeon 5130, 4 GB of DDR2 ECC Reg. RAM and a
two-sata-disc Raid 0 cluster. I don't know the brand of the memory nor the
HDDs. The Riad controller is a 3Ware 80
"Filip Rembiałkowski" <[EMAIL PROTECTED]> wrote:
>
> 2007/9/18, Joshua D. Drake <[EMAIL PROTECTED]>:
>
> > If you overrun your max_fsm_pages then vacuum analyze IS NOT ENOUGH. If
> > you do not overrun your max_fsm_pages, yes vacuum analyze can deal with
> > the issue.
>
> Are you sure? I have a
Robert Wickert would like to recall the message, "August Monthly techdata split
file printers for France and Denmark ".
*
Robert Wickert
Senior Software Developer
CONTEXT
Tel:+44 (0)20 8394 7739
Fax:+44 (0)20 8394 7701
Email Address: [EMAIL PRO
Tom Lane <[EMAIL PROTECTED]> wrote:
> Dániel Dénes <[EMAIL PROTECTED]> writes:
> > But even then, it won't realize that the result are in correct
> > order, and does a sort! Why?
>
> In general the output of a nestloop doesn't derive any ordering
> properties from the inner scan. It might happen
On 9/18/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> On Tue, 2007-09-18 at 06:01 -0400, Bill Moran wrote:
> > * (with newer version) reduce the fill factor and REINDEX
>
> What is fill factor?
See "Index Storage Parameters":
http://www.postgresql.org/docs/8.2/static/sql-createindex.html
-
[EMAIL PROTECTED] wrote:
Robert Wickert would like to recall the message, "August Monthly
techdata split file printers for France and Denmark ".
In my experience, attempting to 'recall' an email message is a fruitless
endeavor. Seems to me that this is a 'Microsoft' creation. I really
don't
ok they're both done
-Original Message-
From: Robert Wickert
Sent: 18 September 2007 11:05
To: Gurvan Meyer
Subject: RE: August Monthly techdata split file printers for France and Denmark
the reports can always be found here .. \\147.114.32.180\monthly_sales_reports\
just find the yea
On Tue, 2007-09-18 at 06:52 -0400, Geoffrey wrote:
> [EMAIL PROTECTED] wrote:
> > Robert Wickert would like to recall the message, "August Monthly
> > techdata split file printers for France and Denmark ".
>
> In my experience, attempting to 'recall' an email message is a fruitless
> endeavor.
On Tue, Sep 18, 2007 at 02:04:32PM +0300, Sabin Coanda wrote:
> Hi there,
>
> I'd like to find the sessions that provide unclosed transactions (i.e.
> marked as in transaction).
>
> Is any way to find the SQL statements that belong to such a transaction, or
> the transaction time start, or any
Hi there,
I'd like to find the sessions that provide unclosed transactions (i.e.
marked as in transaction).
Is any way to find the SQL statements that belong to such a transaction, or
the transaction time start, or any other helpful data ?
TIA,
Sabin
---(end of bro
On 9/18/07, Geoffrey <[EMAIL PROTECTED]> wrote:
> In my experience, attempting to 'recall' an email message is a fruitless
> endeavor. Seems to me that this is a 'Microsoft' creation. I really
> don't understand the purpose, because by the time you consider
> 'recalling' the email message, it's a
Ow Mun Heng wrote:
On Tue, 2007-09-18 at 06:52 -0400, Geoffrey wrote:
[EMAIL PROTECTED] wrote:
Robert Wickert would like to recall the message, "August Monthly
techdata split file printers for France and Denmark ".
In my experience, attempting to 'recall' an email message is a fruitless
endeav
Hi,
The PostgreSQL New RPM Sets
2007-09-17
Versions: 8.2.5, 8.1.10, 8.0.14, 7.4.18, 7.3.20
Set labels: 8.2.5-1PGDG, 8.1.10-1PGDG, 8.0.14-1PGDG, 7.4.18-1PGDG,
7.3.20-1PGDG
Hi,
> Can I add SHM with merely by managing the entry in sysctl.conf? My
> current values:
>
> kernel.shmmax = 536870912
> kernel.shmall = 536870912
>
> My "shared_buffers" in postgresql.conf is "2". From the website
> http://www.desknow.com/kb/idx/12/061/article/ I notice that shmmax
> shou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/18/07 05:54, Ow Mun Heng wrote:
> On Tue, 2007-09-18 at 06:52 -0400, Geoffrey wrote:
>> [EMAIL PROTECTED] wrote:
>>> Robert Wickert would like to recall the message, "August Monthly
>>> techdata split file printers for France and Denmark ".
>> In
Ow Mun Heng wrote:
Hi,
I have 3 tables
foo
foo_loading_source1
foo_loading_source2
which is something like
create table foo (a int, b int, c int)
create table foo_loading_source1 (a int, b int, c int)
create table foo_loading_source2 (a int, b int, c int)
Is there a way which can be made eas
> Unfortunately, folks like Phoenix are looking for yes/no answers, and
> with many of these questions, the _correct_ answer is "it depends on
> your workload"
I wanted merely to simplify the advice that gets dispensed on this
list, often conflicting to novice ears like mine. So I appreciate your
On 9/15/07, Marinos Yannikos <[EMAIL PROTECTED]> wrote:
> this might not be the best place to ask, but has there been any further
> progress or an alternative project to Florian Pflug's SoC 2007 proposal
> about enabling PITR slaves to serve read-only queries? It seems like an
> elegant way to load
Hi,
> Now, I can merrily increase the shared_buffers, but the manual warns
> me against increasing the value too much because it is "per
> transaction" value.
Shared_buffers is not per-transaction. Where did you find this information?
- Sander
---(end of broadcast)
Ow Mun Heng wrote:
The results are valid (verified with actual data) but I don't
understand
the logic. All the Statistical books I've read marked stdev as sqrt
(sum(x - ave(x))^2 / (n - 1). The formula is very different, hence the
confusion.
A formula is not an algorithm. In particular, the
On 18/09/2007, Sander Steffann <[EMAIL PROTECTED]> wrote:
> Hi,
>
> > Can I add SHM with merely by managing the entry in sysctl.conf? My
> > current values:
> >
> > kernel.shmmax = 536870912
> > kernel.shmall = 536870912
> >
> > My "shared_buffers" in postgresql.conf is "2". From the website
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/17/07 23:34, Ow Mun Heng wrote:
> Just wondering how everyone is doing aggregration of production data.
>
> Data which runs in the vicinity of a few million a week.
>
> What are the methods which will effectively provide the
> min/max/average/c
In response to "Phoenix Kiula" <[EMAIL PROTECTED]>:
> > If you find that reindexing improves performance, then you should
> > investigate further. Depending on the exact nature of the problem,
> > there are many possible solutions, three that come to mind:
> > * Add RAM/SHM
>
> Can I add SHM wit
On 9/17/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> Just wondering how everyone is doing aggregration of production data.
Where I work, we aggregate by the minute in the application, then dump
those stats entries into the database en masse from each machine. So,
we wind up with rows something l
On 9/18/07, Alexander Staubo <[EMAIL PROTECTED]> wrote:
> On 9/15/07, Marinos Yannikos <[EMAIL PROTECTED]> wrote:
> > this might not be the best place to ask, but has there been any further
> > progress or an alternative project to Florian Pflug's SoC 2007 proposal
> > about enabling PITR slaves to
"Willy-Bas Loos" <[EMAIL PROTECTED]> writes:
> I'm running a PostgreSQL 8.1.9 server on Debian etch (default installation,
> w/ PostGIS from Debian repositories).
> The machine has double Xeon 5130, 4 GB of DDR2 ECC Reg. RAM and a
> two-sata-disc Raid 0 cluster. I don't know the brand of the memory
On 9/18/07, Willy-Bas Loos <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm running a PostgreSQL 8.1.9 server on Debian etch (default installation,
> w/ PostGIS from Debian repositories).
> The machine has double Xeon 5130, 4 GB of DDR2 ECC Reg. RAM and a
> two-sata-disc Raid 0 cluster. I don't know the br
prueba=# select to_tsvector('espanol','melón');
ERROR: Affix parse error at 506 line
and
prueba=# select lexize('sp','melón');
lexize
-
{melon}
(1 row)
Looks very strange, can you provide list of dictionaries and configurati
Hi! All,
I have come cross many posting that talks about INLINE FUNCTION and
their utility in helping optimizer decide the right plan. However, other
than few posting in different forums I haven't been able to get my hands
on any sort of documentation that explains which function can be converted
On 9/18/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> Florian has been hard at work on getting the lazy xid assignment patch
> in for 8.3, which is now complete. AIUI, this is an important step
> towards read only pitr slave (with other advantages too), and shows
> that things are moving along.
Hi there,
I am new to PostgreSQL, is it possible to create something so that
1) If I insert / update / delete an item from my DB...
2) ... an awk / shell / external program is executed in my UNIX System?
If yes, how do I do this and if no, thanks for telling.
Thanks for reading, any help is app
Tom Lane wrote:
"Gustav Lindenberg" <[EMAIL PROTECTED]> writes:
Why is '' not considered null is postgres (8.1.3)
Because they're different. The SQL spec says that an empty string
is different from NULL, and so does every database in the world except
Oracle. Oracle, however, does not define
i have the log analysis report by using the pgFouine. in the part of
Slowest queries, the update commands " update com_status set
travel=620.70001220703 where no=1" have the high Av.duration(s). how
should i do to solve this problem? why this simple command can take
up
the most time?
Av.duration(
I'm using copy to insert a bunch of rows into a new table with a unique
primary key. Copy is correctly incrementing the primary key, but
apparently the sequence itself is never updated because when I go to
insert again I get a constraint violation.
Here's the start of the new table creation:
CR
> Can I use inheritance? References?
inheritance
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 9/18/07, Jeff Ross <[EMAIL PROTECTED]> wrote:
> I'm using copy to insert a bunch of rows into a new table with a unique
> primary key. Copy is correctly incrementing the primary key, but
> apparently the sequence itself is never updated because when I go to
> insert again I get a constraint vio
On 13 Sep, 06:12, [EMAIL PROTECTED] (Ow Mun Heng) wrote:
> On Mon, 2007-09-10 at 13:00 -0600, RC Gobeille wrote:
> > Or this one:
> >http://schemaspy.sourceforge.net/
>
> Can't seem to get it to connect to PG using the example.
>
> java -jar schemaSpy_3.1.1.jar -t pgsql -u operator -p operator -o
>
Does the planner automatically add "limit 1" to "exists" sub-selects? In
other words, take an update like:
update foo
set itexists = exists
(select 1 from bar where bar.something = foo.something);
If the sub-select returns a large result set, will there be any benefit
to adding "limit 1" to th
In response to "Phoenix Kiula" <[EMAIL PROTECTED]>:
> Thanks for a very informative post! One question:
>
> > I'm not sure how to find the current value, but a smaller fill factor
> > on busy tables should lead to less fragmentation, thus more efficient
> > indexes over time. Keep in mind that a
--- Phoenix Kiula <[EMAIL PROTECTED]> wrote:
> What constitutes a "small fill factor"? Would 70 be good? I guess my
> current must have been the default, which the manual says is 100.
On the following link:
http://www.postgresql.org/docs/8.2/interactive/sql-createindex.html#SQL-CREATEINDEX-STORA
On 9/17/07, Bima Djaloeis <[EMAIL PROTECTED]> wrote:
> Thanks for reading, any help is appreciated.
Triggers + Untrusted PL/Perl, see:
1) http://www.postgresql.org/docs/8.2/static/plperl-triggers.html
2) http://www.postgresql.org/docs/8.2/static/plperl-trusted.html
---(end
On 9/17/07, Bima Djaloeis <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I am new to PostgreSQL, is it possible to create something so that
>
> 1) If I insert / update / delete an item from my DB...
> 2) ... an awk / shell / external program is executed in my UNIX System?
>
> If yes, how do I do this a
am Mon, dem 17.09.2007, um 18:50:46 +0200 mailte Bima Djaloeis folgendes:
> Hi there,
>
> I am new to PostgreSQL, is it possible to create something so that
>
> 1) If I insert / update / delete an item from my DB...
> 2) ... an awk / shell / external program is executed in my UNIX System?
>
> I
On Sep 17, 2007, at 11:50 AM, Bima Djaloeis wrote:
Hi there,
I am new to PostgreSQL, is it possible to create something so that
1) If I insert / update / delete an item from my DB...
2) ... an awk / shell / external program is executed in my UNIX
System?
If yes, how do I do this and if no,
On Sep 17, 2007, at 9:50 AM, Bima Djaloeis wrote:
Hi there,
I am new to PostgreSQL, is it possible to create something so that
1) If I insert / update / delete an item from my DB...
2) ... an awk / shell / external program is executed in my UNIX
System?
If yes, how do I do this and if no,
Here's the situation...
I have 2 different apps that both require a separate shema, or maybe db.
There is actually one column in one table of each ot these db/schemas
that are in common and a desire to :cross" between them in some cases.
For example, an app for keeping track of the census resul
Scott Marlowe wrote:
On 9/18/07, Jeff Ross <[EMAIL PROTECTED]> wrote:
I'm using copy to insert a bunch of rows into a new table with a unique
primary key. Copy is correctly incrementing the primary key, but
apparently the sequence itself is never updated because when I go to
insert again I get
Thanks for a very informative post! One question:
> I'm not sure how to find the current value, but a smaller fill factor
> on busy tables should lead to less fragmentation, thus more efficient
> indexes over time. Keep in mind that a smaller fill factor will also
> lead to larger indexes initia
Hi,
I want to use a SRF to return multi rows.
current SRF is pretty static.
create type foo_type as (
id smallint
data1 int
data2 int
)
CREATE OR REPLACE FUNCTION foo_func()
RETURNS SETOF foo AS
$BODY$
SELECT
TRH.ID,
TRH.data1,
TRH.data2,
FROM D
On Sun, Sep 16, 2007 at 08:03:56PM -0700, Charles.Hou wrote:
> i have the log analysis report by using the pgFouine. in the part of
> Slowest queries, the update commands " update com_status set
> travel=620.70001220703 where no=1" have the high Av.duration(s). how
> should i do to solve this prob
--- "A. Kretschmer" <[EMAIL PROTECTED]> wrote:
> You can do this, you need a untrusted language like plperlU or plsh.
> Then you can write a TRIGGER and call external programs.
This may be a silly question, will plsh work on a windows server? I am pretty
sure that plbat
doesn't exist :-).
Rega
Steve Crawford <[EMAIL PROTECTED]> writes:
> If the sub-select returns a large result set, will there be any benefit
> to adding "limit 1" to the sub-select or does the query planner
> automatically deduce that "limit 1" is the correct interpretation?
It does, although poking at it I notice a bit
Hi list,
I am still fighting with the really slow database queries (see
http://www.nabble.com/%22like%22-vs-%22substring%22-again-t4447906.html),
and I still believe that the cause of the problem is that the query
planner makes incorrect estimations about the selectivity of the "where"
clauses
On Tuesday 18 September 2007 10:30, Ken Logan <[EMAIL PROTECTED]> wrote:
> When we try to drop the table we get the error:
> ERROR: "member_pkey" is an index
You have to remove the table from it's Slony set before you can drop it.
Slony does some hackish things to subscriber tables that make the
Christian Schröder wrote:
Or would it be possible to tweak how the planner determines the
selectivity? I have read in the docs (chapter 54.1) that in case of
more than one condition in the where clause, independency is
assumed. In my case ("... where test like '11%' and test not like
'113
We are using postgresql 8.2.3 with slony1 1.2.8 and we're having
problems trying to drop a table on the slony1 secondary that was
sucessfully dropped on the master database.
I'm sure this is just because I'm missing something, but it doesn't seem
like there should be any reason the table cannot b
On Tue, Sep 18, 2007 at 11:26:17AM +0300, Marko Kreen wrote:
> Few bytes being same is normal. Those are PGP packet header,
> telling "this is symmetrically encrypted session key packet,
> with length X" plus some more details.
I see. So, you are saying no need to generate my own IV to prepend t
--- Gregory Williamson <[EMAIL PROTECTED]> wrote:
> A very low fill factor means that pages are
> "sparse" and so inserts and updates are less likely to trigger massive b-tree
> rebalancings.
I take it that "massive b-tree rebalancings" could cause a problem with the
performance of disk
writi
Richard Broersma Jr wrote:
--- Gregory Williamson <[EMAIL PROTECTED]> wrote:
A very low fill factor means that pages are
"sparse" and so inserts and updates are less likely to trigger massive b-tree rebalancings.
I take it that "massive b-tree rebalancings" could cause a problem with
Sorry for top-posting -- challenged reader.
Can't speak directly to PostgreSQL but in Informix the fill factor is useful
for tweaking indexes. A very high fill factor is useful for tables that are
static -- any inserts or changes to the index trigger a *lot* of moving of
b-tree branches. But th
Ow Mun Heng wrote:
> Data which runs in the vicinity of a few million a week.
>
> What are the methods which will effectively provide the
> min/max/average/count/stdev of the weekly sample size based on different
> products/software mix etc.
>
> and still be able to answer correctly, what's the av
A while back it was pointed out the that the Windows version of 8.2.3 had a bug
that prevented
auto-vacuum from working correctly.
http://archives.postgresql.org/pgsql-general/2007-04/msg00139.php
I wasn't able to determine from the release notes if this bug was fixed in
versions 8.2.4 or
8.2.5
On Tue, 2007-09-18 at 11:10 -0700, Alan Hodgson wrote:
> On Tuesday 18 September 2007 10:30, Ken Logan <[EMAIL PROTECTED]> wrote:
> > When we try to drop the table we get the error:
> > ERROR: "member_pkey" is an index
>
> You have to remove the table from it's Slony set before you can drop it.
Hi
You are rigth, the output of "show lc_ctype;" is C.
Then I did is:
prueba1=# show lc_ctype;
lc_ctype
-
es_MX.ISO8859-1
(1 row)
and do it
% initdb -D /YOUR/PATH -E LATIN1 --locale es_ES.ISO8859-1
(how you do say)
and "createdb -E iso8859-1 prueba1" and finally ts
Hello,
I just upgraded from 8.2.4 to 8.2.5 on Windows but the service doesn't
startup normally.
This is the first time I have trouble with an upgrade of version 8.2.
I have the following non standard configuration:
- Program directory: C:\Archivos de programa\PostgreSQL\8.2\bin
- Data Directory:
I had two versions of postgresql running on a Redhat 9 server. Today I
shut down the 7.3.4 version and uninstalled it using the RPM's.
Unfortunately, as far as I can tell, this deleted the postgres user
account and the system's knowledge of the posgresql 8.1.4 software. The
system will no long
On Tue, 2007-09-18 at 09:55 -0500, Scott Marlowe wrote:
> On 9/17/07, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
>
> > Just wondering how everyone is doing aggregration of production data.
>
> Where I work, we aggregate by the minute in the application, then dump
> those stats entries into the databa
On 9/18/07, Ken Logan <[EMAIL PROTECTED]> wrote:
>
>
> On Tue, 2007-09-18 at 11:10 -0700, Alan Hodgson wrote:
>
> On Tuesday 18 September 2007 10:30, Ken Logan <[EMAIL PROTECTED]> wrote:>
> When we try to drop the table we get the error:> ERROR: "member_pkey" is an
> index
> You have to remove t
am Mon, dem 17.09.2007, um 9:21:22 +0800 mailte Ow Mun Heng folgendes:
> CREATE OR REPLACE FUNCTION foo_func(fromdate timestamp, todate
> timestamp, code text)
> RETURNS SETOF foo AS
> $BODY$
> SELECT
> TRH.ID,
> TRH.data1,
> TRH.data2,
> FROM D
> INNER JOIN
75 matches
Mail list logo
