Thank you to all for the interesting replies !
Best regards,
N.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Dear Sam...
After I found the solution of my problem and again read the postgres
manual, I've understood you're correct that I tried "too much" as an
initial step for a newbie like me.
But anyway, I thank you so many times because you've taught me a
lot about postgres.
I really appreciate yo
Dear Alban.
You've solved my problem
Thank you 1000x.
On Sun, 27 Sep 2009 11:36:09 +0200
Alban Hertroys wrote:
> On 27 Sep 2009, at 10:44, Ricky Tompu Breaky wrote:
>
> > RB>I forgot to show you that I've done these steps too:
> > postgres=# ALTER ROLE ivia WITH LOGIN;
> > ALTER ROLE
> >
Hi, all.
Sorry, I did not check these mail
2009/7/27 Tom Lane :
> sibu xolo writes:
>> + " tas.b �...@%1\n\t \n"
>> + " movt %0\n\t \n"
>> + " xor #1,%0 \n"
>
> Hmm, what is the point of introducing extra blank lines into the a
Grant Maxwell writes:
> What I'm trying to do is find every record where "my name" is not in
> the array.
> So I tried <> ANY and also <> ALL and both returned an empty row set.
Maybe you have some nulls in the arrays? <> ALL works for me.
regards, tom lane
--
Sent v
Hi Tom
The bit I was reading is
http://www.postgresql.org/docs/8.3/interactive/arrays.html#AEN6019
__ EXTRACT
However, this quickly becomes tedious for large arrays, and is not
helpful if the size of the array is uncertain. An alternative method
is described in Section 9.20. Th
Grant Maxwell writes:
> According to the 8.3 docs I should be able to write:
> select * from tblretrain where 'ms-ap-t2-02c9' NOT IN (owners);
> where owners is an array per the following definition
>owners character varying(1024)[],
No, what you can write is "<> ALL", not NOT IN.
> It s
Hi Folks
According to the 8.3 docs I should be able to write:
select * from tblretrain where 'ms-ap-t2-02c9' NOT IN (owners);
where owners is an array per the following definition
CREATE TABLE tblretrain
(
pkretrainid integer NOT NULL,
mailid integer NOT NULL,
train_to smallint NOT NU
>
>> dd if=/dev/zero of=test.txt bs=8192 count=1310720 conv=fdatasync
>> 10737418240 bytes (11 GB) copied, 169.482 s, 63.4 MB/s
>>
>> dd if=test.txt of=/dev/null bs=8192
>> 10737418240 bytes (11 GB) copied, 86.4457 s, 124 MB/s
>
> These look slow. RAID5 isn't going to be amazing, but it should be
On Sun, Sep 27, 2009 at 5:44 PM, InterRob wrote:
> Oliver,
> Would you say it is not valid for proposition 2 (people wanting to be able
> to quickly add (and remove?) attributes) because within the relational model
> this can be done reasonably well?
Actually that's what I think it's best at, as
When we upgraded from linux-2.6.24 to ./linux-2.6.27, our pg_dump
duration increased by 20%. My first attempt at resolution was to boot
with elevator=deadline. However that's actually the default IO
scheduler in both kernels.
The two dmesg's are at:
https://www.norchemlab.com/tmp/linux-2.6.24-22
Oliver,
Would you say it is not valid for proposition 2 (people wanting to be able
to quickly add (and remove?) attributes) because within the relational model
this can be done reasonably well?
If you think so, then I we do in fact agree on that... Still, however,
implementing this transparently (
On Sun, Sep 27, 2009 at 10:01:27PM +0100, Sam Mason wrote:
> Tested by turning on "\timing" mode in psql, dropping
> caches and running:
>
> SELECT 715833344 / 7597.216 / 1024;
Help, I can't do maths! This is overestimating the performance and
should be:
SELECT 715833344 / 7597.216 / 1024 /
On 27 Sep 2009, at 21:10, InterRob wrote:
Peter, may I invite you to privately share some more details on the
system you are using and the design of it? Did you implement it
using PostgreSQL? Looking forward to your reply.
(And with respect to your previous message: whom are you actually
On Sun, Sep 27, 2009 at 09:04:31PM +0200, Gerhard Wiesinger wrote:
> I'm talking about 2 cases
> 1.) Sequential scans
> 2.) Bitmap index scans
> which both hopefully end physically in blocks which are after each other
> and were larger block sizes can benefit.
Unfortunately it's all a bit more co
Dear David, dear Peter, dear all,
Peter, I was happy reading your reply right after I opened and read Davids.
I do think I am on the right track; it is not a matter of building the
one-and-only right schema, not in this case. Archaeology has the same twist
as has ethnography, antropology and alike:
On Sun, Sep 27, 2009 at 2:22 PM, David Fetter wrote:
> On Sun, Sep 27, 2009 at 08:26:27PM +0200, InterRob wrote:
>> Dear David, dear all,
>> I very well understand what you are saying...
>
> Clearly you do not. What you are proposing has been tried many, many
> times before, and universally fails
On Sun, Sep 27, 2009 at 08:26:27PM +0200, InterRob wrote:
> Dear David, dear all,
> I very well understand what you are saying...
Clearly you do not. What you are proposing has been tried many, many
times before, and universally fails.
That your people are failing to get together and agree to a
Carlo Camerino writes:
> I have questions regarding tablespaces, What happens when the disk on
> which my tablespace is in fills up?
You start getting errors.
> How do I expand my tablespace, in oracle there is a concept of
> datafiles? In postgresql I specify a directory instead of a single
> f
Martin Gainty writes:
> I am slowly transferring my Procedures over and came upon this workaround
> implemented by a script which maps the plpgsql (type) to call plpgsql.dll
> pg_finfo_plpgsql_call_handler
> # Create a plpgsql handler for plpgsql type
> CREATE FUNCTION pg_finfo_plpgsql_call_han
On Sun, 27 Sep 2009, Sam Mason wrote:
On Sun, Sep 27, 2009 at 06:05:51PM +0200, Gerhard Wiesinger wrote:
A google research has shown that Gregory Stark already worked on that issue
(see references below) but as far as I saw only on bitmap heap scans.
Greg Stark's patches are about giving the
In fact, I considered doing so, yes... But no luck: to complicate things, I
will need the support for spatial datatypes, as implemented by the contrib
"PostGIS"... Moreover: various applications that will make-up the front-end,
will only be able to talk with mainstraim or ODBC-compatible databases
2009/9/27 Martin Gainty :
> I am slowly transferring my Procedures over and came upon this workaround
> implemented by a script which maps the plpgsql (type) to call plpgsql.dll
> pg_finfo_plpgsql_call_handler
>
> # Create a plpgsql handler for plpgsql type
> CREATE FUNCTION pg_finfo_plpgsql_call_h
Hi Everyone,
I have questions regarding tablespaces, What happens when the disk on
which my tablespace is in fills up?
How do I expand my tablespace, in oracle there is a concept of
datafiles? In postgresql I specify a directory instead of a single
file...
For example I have two tables and they b
Dear David, dear all,
I very well understand what you are saying... However, the solution won't be
found in the direction you are suggesting: the system I am designing will be
used by archaeologists, involved in archaeological research (fieldwork).
Their research strategy (and with it their methodo
I am slowly transferring my Procedures over and came upon this workaround
implemented by a script which maps the plpgsql (type) to call plpgsql.dll
pg_finfo_plpgsql_call_handler
# Create a plpgsql handler for plpgsql type
CREATE FUNCTION pg_finfo_plpgsql_call_handler() RETURNS plpgsql AS
'/pos
On Sun, Sep 27, 2009 at 06:05:51PM +0200, Gerhard Wiesinger wrote:
> A google research has shown that Gregory Stark already worked on that issue
> (see references below) but as far as I saw only on bitmap heap scans.
Greg Stark's patches are about giving the IO subsystem enough
information about
Hello,
As blocksizes, random I/O and linear I/O are critical I/O performance
parameters I had a look on PostgreSQL and a commercial software vendor.
Therefore I enhanced the system tap script:
http://www.wiesinger.com/opensource/systemtap/disktop_gw.stp
Output per 5 seconds on a sequence sc
Adam Rich writes:
> Please reference these explain plans. This is Pg 8.4.1
> http://explain-analyze.info/query_plans/4032-query-plan-2745
> http://explain-analyze.info/query_plans/4033-query-plan-2746
> First, could somebody explain what is leading the first query to choose
> a different plan
Hello,
As blocksizes, random I/O and linear I/O are critical I/O performance
parameters I had a look on PostgreSQL and a commercial software vendor.
Therefore I enhanced the system tap script:
http://www.wiesinger.com/opensource/systemtap/disktop_gw.stp
Output per 5 seconds on a sequence sc
On Sat, Sep 26, 2009 at 03:00:41PM +0700, Ricky Tompu Breaky wrote:
> You've solved my several problem. But now I'm stucked on another
> problem which I know easy to anybody else but difficult as a
> postgres starter like me.
A general observation; you seem to be making things awfully complicated
On Sun, Sep 27, 2009 at 2:36 AM, Ricky Tompu Breaky wrote:
> Welcome to psql 8.3.7, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute quer
On 27 Sep 2009, at 10:44, Ricky Tompu Breaky wrote:
RB>I forgot to show you that I've done these steps too:
postgres=# ALTER ROLE ivia WITH LOGIN;
ALTER ROLE
postgres=# alter user ivia with password '<>';
ALTER ROLE
postgres=# alter user ivia with login;
ALTER ROLE
postgres=# commit;
WARNUNG: k
Hello,
I think the limit of bgwriter_lru_maxpages of max. 1000 doesn't make any
sense because in fact it limits performance of the database (version 8.3).
On heavy write operations buffer cached must be freed. With the default
config this is practically limited to:
bgwriter_delay=200ms
bgwri
On Sun, 27 Sep 2009 15:36:33 +0700
Ricky Tompu Breaky wrote:
> On Sat, 26 Sep 2009 09:35:27 -0400
> Bill Moran wrote:
>
> > Ricky Tompu Breaky wrote:
> > >
> > > Dear my friends...
> > >
> > > I've installed postgresql-server on OpenSuSE11.1 successfully but
> > > I can't connect to it from p
On Sat, 26 Sep 2009 09:35:27 -0400
Bill Moran wrote:
> Ricky Tompu Breaky wrote:
> >
> > Dear my friends...
> >
> > I've installed postgresql-server on OpenSuSE11.1 successfully but I
> > can't connect to it from psql.
> >
> > I did these steps:
> > "
> > 1. I created a new opensuse11.1-linux
Hello,
Please reference these explain plans. This is Pg 8.4.1
http://explain-analyze.info/query_plans/4032-query-plan-2745
http://explain-analyze.info/query_plans/4033-query-plan-2746
First, could somebody explain what is leading the first query to choose
a different plan that's much slower?
37 matches
Mail list logo
