Hi.
Sometimes order of rows readed from index allows to skip sort node.
But sometimes planner don't deduce it. In example below order from index
NumerStacji_NumerKierunkowy_KodBłędu_LP
is preserved in merge join and can be used in groupping node, but planner
don't see it.
First query and
Hi.
I recreate database and a problem disapears.
Thanks.
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi.
When i add extensions: cube and btree_gist.
First extension installs, but second not.
There is a (spelled) error message:
ERROR: operator 6(oid,oid) already exists in operator's family gist_oid_ops
I try to install it in other schema, but i don't know how to use it.
--
pasman
Hi.
I have a table with two columns:
create table GroupsOfOrders (
Orders text[]; -- a set of identifiers
Period cube; -- a period of time for all identifiers in field Orders
);
How to create excluding constraint, which prevent overlapping Period
for all orders in a field Orders ?
Hi.
I think that in specific statement with many constants:
CASE x
WHEN const1 THEN action1
WHEN const2 THEN action2
WHEN const3 THEN action3
WHEN const4 THEN action4
END CASE;
constants may be sorted at compile time, and when executed ,
it will be possible internally to use fast
Thanks.
Hstore works perfectly.
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi.
I write function in pgsql. This function needs
to execute other functions by name.
I do it using loop:
declare r record;
begin
for r in execute 'select ' || $1 || '()'
loop
end loop;
But I can't convert a record to array of text.
How to do it ?
pasman
--
Sent via
Hi.
I try to monitor a progress of the insert statement:
insert into table1
(id,other fields)
select
id+0*nextval('public.progress'),other fields
From second session i run:
select nextval('public.progress');
but sequence 'progress' looks unchanged.
How to display number of processed rows
See documentation, chapter Viii.E.2.2.2
2011/11/11, Chris Travers chris.trav...@gmail.com:
Hi;
I have found recently that tables in certain contexts seem to have a
name pseudocolumn. I was wondering if there is any documentation as
to what this is and what it signifies.
postgres=# CREATE
Hi.
Is any application, which works as www server on client's side, and
loads pages from postgresql database? (free or commercial)
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
O'Donnell r...@iol.ie:
On 07/11/2011 20:13, pasman pasmański wrote:
Hi.
Is any application, which works as www server on client's side, and
loads pages from postgresql database? (free or commercial)
Many. Depends on what you want to do care to be a bit more specific?
Wikimedia
Hi.
I can't set proper encoding for pgAgent.
I have two databases: postgres and www.
postgres is encoded in UTF8, www is encoded in WIN1250.
When i run pgAgent's task in www database, it fail (message char cant
be converted to UTF8):
2011-10-27 14:50:29 CEST [nieznany] 1.COPY
BŁĄD:
Hi.
I can't compile odbc_fdw module:
make: Entering directory `/e/pg91/postgres/contrib/odbc_fdw'
dllwrap -o odbc_fdw.dll --dllname odbc_fdw.dll --def libodbc_fdwdll.def odbc_fd
w.o -L../../src/port -Wl,--allow-multiple-definition -Wl,--as-needed -lodbc -
L../../src/backend -lpostgres
Unlogged tables can't be temporary.
2011/10/13, Ivan Voras ivo...@freebsd.org:
On 13/10/2011 14:34, Alban Hertroys wrote:
Any other ideas?
CREATE TABLE to_delete (
job_created timestamp NOT NULL DEFAULT now(),
fk_id int NOT NULL
);
-- Mark for deletion
INSERT INTO to_delete (fk_id)
This beaviour is normal. Bitmap index scan is faster than index scan.
2011/10/8, hubert depesz lubaczewski dep...@depesz.com:
hi
did:
create table test as select i as id, i || ' ' || repeat('depesz', 100) as z
from generate_series(1,3000) i;
create index q on test (id);
vacuum verbose
You should to create new database with two empty tables, set access
rights for all schemas readonly and pipe backup to this database.
2011/10/5, Dickson S. Guedes lis...@guedesoft.net:
2011/10/5 Adarsh Sharma adarsh.sha...@orkash.com:
About 1 month ago, I take a complete databases backup of my
Its simple to remove strange chars with regex_replace.
2011/10/1, Leif Biberg Kristensen l...@solumslekt.org:
On Saturday 1. October 2011 21.29.45 Andrew Sullivan wrote:
I see you found it, but note that it's _not_ a spurious UTF-8
character: it's a right-to-left mark, ans is a perfectly ok
Look at doc chapter II.12
2011/9/30, haman...@t-online.de haman...@t-online.de:
Hi,
I have a table of names, and searches are usually performed on prefix match.
This could nicely translate into an index search
Suppose first name is stored as either 'Jim' or 'Jimmy', searching
... where
Yes, accumulative functions may be used for sorting,groupping and
merge joins with limit.
Groupping looks simplest to implement, and comparable to performance
of functional index
.
2011/9/27, Marti Raudsepp ma...@juffo.org:
2011/9/25 pasman pasmański pasma...@gmail.com:
My english
Thanks Marti for inspiration :). Monotonic functions allows to skip
some sorts in window expressions containing them:
select winfun1(...) over(order by x), winfun2(...) over(order by f(x)) from ...
2011/9/27, pasman pasmański pasma...@gmail.com:
Yes, accumulative functions may be used
Hi.
I propose to add accumulative flag to a function definition. This
flag would be set for function f(x) which is accumulative and
immutable.
This flag allows to use an index on x for clauses containing f(x):
where f(x) = const
where f(x) const
and so on.
--
pasman
--
My english is not perfect, by accumulative i think about monotonically
increasing function.
It works that for clause WHERE f(x)=const:
1. Read root page of index_on_x and get x1 ... Xn
2. Calculate f(x1) ... f(xn) for this page
3. When f(x1)=const= f(xn) then x1 = searched x = xn and we can
test
I think, it should be new node in executor. Planner select classic
index scan or new functional index scan.
2011/9/25, Tom Lane t...@sss.pgh.pa.us:
=?ISO-8859-2?Q?pasman_pasma=F1ski?= pasma...@gmail.com writes:
My english is not perfect, by accumulative i think about monotonically
increasing
... When n changes of course.
Sorry for top posting, phone not allows to move cite.
2011/9/25, pasman pasmański pasma...@gmail.com:
I found second use case. Look at expression:
where left(str,n)='value'
function left(str,n) increase monotonically for str and n. With this
feature it can use
?
Regards
Pavel
2011/9/25 pasman pasmański pasma...@gmail.com:
My english is not perfect, by accumulative i think about monotonically
increasing function.
It works that for clause WHERE f(x)=const:
1. Read root page of index_on_x and get x1 ... Xn
2. Calculate f(x1) ... f(xn) for this page
3
This feature give profits for increasing muliti-arg functions. Example:
WHERE f(x,param) = const
it may be impossible to create functional indexes for all params.
2011/9/25, Pavel Stehule pavel.steh...@gmail.com:
Hello
what is a real use case?
Regards
Pavel
2011/9/25 pasman pasmański
See that setting flag on function need less work than create new gist
operator. Of course if postgresql's developers do biggest work before.
2011/9/25, Pavel Stehule pavel.steh...@gmail.com:
2011/9/25 pasman pasmański pasma...@gmail.com:
I found second use case. Look at expression:
where
Yes, i wrote this for pleasure and discusion, not for solve a real problem :).
2011/9/25, Tom Lane t...@sss.pgh.pa.us:
=?ISO-8859-2?Q?pasman_pasma=F1ski?= pasma...@gmail.com writes:
I found second use case. Look at expression:
where left(str,n)='value'
function left(str,n) increase
For single argument strict increasing function f(x), estimation is
simple: it is f(estimation of x).
2011/9/25, Pavel Stehule pavel.steh...@gmail.com:
2011/9/25 pasman pasmański pasma...@gmail.com:
See that setting flag on function need less work than create new gist
operator. Of course
I write small summary.
Feature details: additional flags for monotonical functions. Learn
planner to use them. New node in execution plan - functional index
scan.
Pro: single btree index may be used in many expressions containing
only monotonnical functions.
Contra: big developement effort. No
You can install pgadmin, it contain s psql.
2011/9/22, Andreas maps...@gmx.net:
Hi,
can I just install psql on windows?
Just the client without the server.
There ist the server release as zip-file that includes psql so I at
least hadn't had to actually install a service with a db cluster
Hi.
In 9.1 is cool feature - foreign tables. But when create foreign table
in pgadmin (file_fdw wrapper), strings in the OPTIONS section ignore
setting standard_conforming_strings=on. I don't know if it is a bug
in postgres or pgadmin.
--
pasman
--
Sent via pgsql-general mailing
Hi.
I propose that some options for foreign tables may be stored as
defaults in server object: format, encoding, delimiter, quote.
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Trigger may store timestamp to other table timestamps. You join then
xmin with xmin from this table to access timestamp.
2011/9/17, Raghavendra raghavendra@enterprisedb.com:
Thank you for your valuable inputs.
Agreed, with the help of two workarounds we can pull the trx-timestamp one
with
Hi.
I install postgresql 9.1.0 version Win32 from enterprisedb (WinXp+sp3).
Every about 0,5 - 6 hours server stops.
Whats going on ??
Below a example log file:
2011-09-14 08:49:37 CEST FATAL: the database system is starting up
2011-09-14 08:49:38 CEST LOG: checkpoint complete: wrote 2179
I think that using any function in plperlu language stops the server.
Perl version is 5.14 from activestate.
2011/9/14, pasman pasmański pasma...@gmail.com:
Hi.
I install postgresql 9.1.0 version Win32 from enterprisedb (WinXp+sp3).
Every about 0,5 - 6 hours server stops.
Whats going
Other option is use an array of int2 instead of bit(256). It can be indexed.
2011/9/14, Radosław Smogura rsmog...@softperience.eu:
On Wed, 14 Sep 2011 12:00:35 +0200, Antonio Vieiro wrote:
Hi all,
One of my entities 'E' may be 'tagged' with an arbitrary set of 256
tags 'T'.
A first
Hi. Do you have triggers on corrupted tables?
2011/9/12, Dylan Adams dylan.adams.w...@gmail.com:
We moved to PostgreSQL about 2 years ago and have been very happy with it
overall. The only major issue that we've had is intermittent index
corruption.
This manifests itself as either duplicate
Hi.
I have the cluster created under 9.1rc version. When i do upgrade to
9.1.0, i can only reinstall binaries or i should import data too?
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Thank you.
Have a nice day :)
2011/9/13, Tom Lane t...@sss.pgh.pa.us:
=?ISO-8859-2?Q?pasman_pasma=F1ski?= pasma...@gmail.com writes:
I have the cluster created under 9.1rc version. When i do upgrade to
9.1.0, i can only reinstall binaries or i should import data too?
Should work to just
Try a command LOCK NOWAIT
2011/9/8, Eduardo Piombino drak...@gmail.com:
Hi, would it be possible to implement a *nowait *modifier to the
*update*statement in order to tell it not to wait and raise an error
-just like a
select for update nowait would-, instead of defaulting to waiting forever
The win32 packages require whatever version of Perl they were built
against, AFAIK. Perl DLLs are only binary compatible within a major
version, and I think the DLL naming changes too.
Looks like 9.1 binaries are linked with perl 5.14.
Thanks for answers
pasman
--
Sent via pgsql-general
Hi.
I have installed activeperl 5.10. It works with pg8.4, but not with
9.1rc1 (win32 installer).
Do this version need perl 5.12?
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
That's interpretation of subselect is ok, when it contains only stable
functions.
Maybe add a warning when subselect contains volatile function.
2011/9/2, Rory Campbell-Lange r...@campbell-lange.net:
On 02/09/11, Tom Lane (t...@sss.pgh.pa.us) wrote:
Rory Campbell-Lange r...@campbell-lange.net
Hi.
Is this possible to force pg_dump to
make backups using COPY ... BINARY ?
Simple benchmark show that COPY BINARY is 8 times faster
than COPY CSV on my desktop.
Postgresql 8.4.8 , WinXp sp3
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Simple benchmark show that COPY BINARY is 8 times faster
than COPY CSV on my desktop.
I retry benchmark, and differences are small.
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Thanks, i'll try it tomorrow
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Do you tried , ?
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi.
Is this possible to limit number of connections for given user/role?
Postgres 8.4.8.
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
What if you run this query using psql?
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
You can add a trigger and send message every 10 rows
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
The better solution is you write own hashing function.
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi. Maybe last bugfix helps you.
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Array_agg is not implemented for arrays.
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Try to change index: objects_endings_tsz_active(state,endings_tsz)
where state='active'.
2011/8/8, hubert depesz lubaczewski dep...@depesz.com:
Hi,
we have 8.3.11 installation on client site, with table, which looks like
this:
$ \d objects
Table
Here may be other problem.
Show us the result of EXPLAIN Analyze.
2011/8/8, Pavel Stehule pavel.steh...@gmail.com:
Hello
use a functional index
http://www.postgresql.org/docs/8.4/interactive/indexes-expressional.html
Regards
Pavel Stehule
2011/8/8 - - loh@hotmail.com:
For a table
Hi.
Today i have an idea for increase performance of foreign keys. After
search parent record, store ctid in shared memory. Subsequent searches
look first to the record at stored ctid, and when it is deleted do
regular search using index.
Pro: faster searching for common keys when parent table
Reality is crude, seems than this idea is not as good as i think :(
Thanks for answer.
2011/7/9, Craig Ringer cr...@postnewspapers.com.au:
On 9/07/2011 3:06 PM, pasman pasmański wrote:
Hi.
Today i have an idea for increase performance of foreign keys. After
search parent record, store ctid
If you rewrite your function in plperlu , you can store data in shared memory.
2011/6/9, Clemens Schwaighofer clemens.schwaigho...@e-graphics.com:
Hi,
I have a plpgsql function where I read data from a table in a loop and
update data in a different table.
Is it possible to see the updated
Try auto_explain module.
2011/5/5, John Cheng johnlich...@gmail.com:
Hi,
We have certain types of query that seems to take about 900ms to run
according to postgres logs. When I try to run the same query via
command line with EXPLAIN ANALYZE, the query finishes very quickly.
What should I do
No.
2011/4/30, Jon Smark jon.sm...@yahoo.com:
Hi,
Does Postgresql perform short-circuit boolean evaluation both in SQL
and PL/pgSQL functions? As an example, suppose I have a function called
do_stuff which is computationally intensive. In the example below,
will it be called for rows for
Hi. Yesterday i have an idea, that sometimes row locks may be skipped,
when table is already locked with LOCK command. It may to reduce an
overhead from row locks.
What do you think about it?
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Maybe you think about WITH queries?
2011/4/17, Robert J.C. Ivens rob...@roclasi.com:
On 17 apr 2011, at 13:21, Leif Biberg Kristensen wrote:
On Sunday 17 April 2011 13:01:45 Robert J.C. Ivens wrote:
Hi,
I am not sure if there ever was a feature request for using defined
column
aliases in
Hi.
It is sometimes hard to tune complicated queries. Maybe add new
attribute to functions returning boolean - selectivity, defining how
big is percent of rows for which the function returns true.
2011/4/15, Edison So edison@gmail.com:
I have a DELL server running Windows server 2003 and
A perl script, perhaps? You would of course have to make a query to
determine that the specific row you are looking for is either null or
nonexistant, then send your additional queries.
Yes, it is simplest. I try to do it
pasman
--
Sent via pgsql-general mailing list
was pointed to the fact that security definer functions have the same
default privileges as normal functions in the same language - i.e. if
the language is trusted - public has the right to execute them.
maybe i'm missing something important, but given the fact that security
definer
Hello.
I search a tool to send queries to database when
specific rows contain null or not exist.
What can be used for this purpose ?
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hi.
How to convet xmin field (32bit) to format used by txid_current (64bit) ?
I use it to track updates in table.
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi. Your idea is cool - i think this feature ought to be added to
TODO. Sorted rows should be materialized when memory is exhaused, and
memory reused.
2011/3/26, Jeremy Palmer jpal...@linz.govt.nz:
Hi Scott,
It was the work_mem that was set too high. I reduced it to 32mb and the
function
Naturally a boolean can only have two values,
really?
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
You read the doc about archiving and pitr.
2011/2/15, Emi Lu em...@encs.concordia.ca:
Start from vacuum feature information from PGSQL helps documentation, it
telling me that Postgresql didn’t delete data permanently when we
execute delete command, it just made the data invalid. By following
Hi.
Is it possible to log plans which planner discard?
I want to tune planner settings for some queries.
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2011/2/13, Ruben Blanco rubenb...@gmail.com:
Hi:
I'm running a Postgres database with a total disk occupation of 100Gb,
largest and most used table up to 40Gb (about 30.000.000 tuples).
Overall performance degrades sometimes due to some queries that are not run
by the final user app. I
Try:
execute ... using new.*
2011/2/10, Gerd Koenig koe...@transporeon.com:
Hello list,
I'm currently thinking about a possibility to create a dynamic insert
statement inside a trigger function to put the data in the correct
partition.
What am I talking about ?
I want to put data dependant
I think this is bad idea. Better you use cursors.
2011/2/10, Alessandro Candini cand...@meeo.it:
Here you are my probably uncommon situation.
I have installed 4 different instances of postgresql-9.0.2 on the same
machine, on ports 5433, 5434, 5435, 5436.
On these instances I have splitted a
2011/2/8, Mike Christensen m...@kitchenpc.com:
Here's the error:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for
relation pantryitems
pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE
Does the user need to be a
Hi.
I propose new feature.
Before flushing page of table to disk it may be scanned to reclaim
deleted rows. And assigned as partially vacuumed or vacuumed.
It may reduce bloat in frequently updated tables and make normal
(auto)vacuum faster.
Additional scan adds overhead to cpu (for
Your trigger is wrong. You try to insert the same row twice.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Look at unnest function.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Mage, add raise notice at the begin of your buggy trigger.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Try :
order by index_delta+1 desc
On 1/15/11, Tim Uckun timuc...@gmail.com wrote:
I have this query it runs reasonably quickly.
SELECT consolidated_urls.* FROM consolidated_urls INNER JOIN
topical_urls
ON consolidated_urls.id = topical_urls.consolidated_url_id
WHERE
I think this is a planner's bug. Can you send these explains to pgsql-bugs ?
On 1/15/11, Tim Uckun timuc...@gmail.com wrote:
2011/1/15 pasman pasmański pasma...@gmail.com:
Try :
order by index_delta+1 desc
I have attached the explain analyze for that below why does this
return instantly
It is need tip in doc which version of perl must be installed. Error
message tells nothing. For example Postgres 8.4 works only with perl
5.10.
--
Sent from my mobile device
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Hi. I propose new feature - allow archive command to copy part of not
full filled wal segment. It need new parameter %b - number of bytes
used in segment . Then one can use head or dd to archive wal and
reduce network traffic to standby server.
--
Sent from my mobile device
pasman
Thanks for reply.
I do some checking and
some queries boost very well :)
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello.
I use Postgres 8.4.5 via perl DBI.
And i try to use cursors WITH HOLD to materialize
often used queries.
My question is how many cursors may be
declared per session and which memory setting s
to adjust for them ?
regards.
pasman
--
Sent via pgsql-general mailing list
I read in doc that by default longer text fields are compressed.
They may be sent to client without decompression - this reduce
netword load.
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hello. Is postgresql able to compress data sent to the client?
--
Sent from my mobile device
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hello.
I think that left/right joins and limit may be optimized.
When there aren't WHERE conditions this may be executed as below:
Limit N
Merge Left Join
Sort Top N
Bitmap Heap Scan
...
Sort
Bitmap Heap Scan
...
pasman
--
Sent via pgsql-general mailing
2010-12-13 11:19:35 CET FATAL: the database system is starting up
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello.
I have a query which works a bit slow.
It's runned on desktop computer: AMD Athlon X2 2GHz , Win Xp sp2, 1GB ram.
Postgres 8.4.5 with some changes in config:
shared_buffers = 200MB # min 128kB
# (change requires restart)
temp_buffers = 8MB
Hello.
How to read binary file ?
I try pg_read_file() but this returns text
(not bytea) and skip part of record
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello.
How to add comment on table with calculated value ?
COMMENT ON TABLE test IS 'Updated ' || current_date;
not works ...
Regards.
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hello.
I propose 2 features for planner:
1. Planner will estimate 2 x statistics: time of query with cache empty
and with cache filled.
2. Two levels of plannig: standard and long.
Long planning may be used when standard optimization
generate slow plan, and may use advanced algebraic
Hello.
I have to prepare manual to simple database in postgresql 8.4.4,
Winxp+sp2. I want to store doc pages in comment field, format html. Is
a better idea to store documentation ? thanks for answer
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Hello.
I have 2 questions:
Is effective_io_concurrency working on WinXP sp2 ?
and what is the difference between effective_io_concurrency = 0
and effective_io_concurrency = 1
Postgres 8.4.4
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
I create partitions as below.
And run query: select * from test where grupa='A';
Is planner skip to analyze partitions: test2d, test2e, test2f ?
best regards
-
CREATE TABLE test (
grupa character varying(1),
Hello.
I'm install postgresql 8.4.3 on WinXPsp3.
Because of small disk i create tablespace
pointing to commpressed folder and move
some tables to it.
Compression is good: 10GB to 3-4GB
speed acceptable (small activity,10 users)
But is this safe ?
pasman
98 matches
Mail list logo