> Date: Fri, 22 Nov 2013 20:11:47 +0100
> Subject: Re: [GENERAL] ERROR: out of memory DETAIL: Failed on request of size
> ???
> From: t...@fuzzy.cz
> To: bwon...@hotmail.com
> CC: brick...@gmail.com; pgsql-general@postgresql.org
>
> On 19 Listopad 2013, 5:30, Brian Wong wrote:
> > I've tried any
Hello everyone.
I'm using PostgreSQl 9.2 on the windows XP
in recovery.conf use command
*standby_mode = 'on'
primary_conninfo = 'host=10.0.10.2 port=5432 user=postgres password =
password'
restore_command = 'copy 10.0.10.2\\archiver\\%f %p'
restore_command = 'pg_standby -d -s 5 -t C:
After spending all day trying all the suggestions to get past this error
while trying to install PostgreSQL on Windows 7 64-bit, I finally was given
one that works. The EnterpriseDB guys gave me a link to one of their
pages, I entered the error msg in their search box which found this forum
page w
On 11/28/2013 10:27 AM, N wrote:
Thanks, but still not same. For example, is there subquery flattening
, is there any other query re-write ? is there website or books have
such detail ?
http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/optimizer/README;h=adaa07ee60eebef0
Thanks, but still not same. For example, is there subquery flattening
, is there any other query re-write ? is there website or books have
such detail ?
On Thu, Nov 28, 2013 at 5:54 PM, Adrian Klaver wrote:
> On 11/28/2013 09:46 AM, N wrote:
>>
>> Are there documents specifying the query optimis
On 11/28/2013 09:46 AM, N wrote:
Are there documents specifying the query optimisations in Postgresql
like the SQLite (http://www.sqlite.org/optoverview.html)?
http://www.postgresql.org/docs/9.3/interactive/overview.html
http://www.postgresql.org/docs/9.3/interactive/performance-tips.html
Fr
Are there documents specifying the query optimisations in Postgresql
like the SQLite (http://www.sqlite.org/optoverview.html)?
>From the web, I can say, there are index and join optimisation, but
are there anything others like Subquery flattening?
thanks.
Bentley.
--
Sent via pgsql-general ma
Hi,
This query (postgis) didn't endup after 4 hoursand eat 40gig of disk
space
SELECT id, gridcode, ST_Difference(a.geom32198_s,b.geom32198_s) as
geom32198_s
into potentialite
FROM province as a, potentialite_tmp as b;
I stopped the execution and cancel request sent appears, but after
2013/11/28 bricklen
> On Wed, Nov 27, 2013 at 11:28 PM, Pavel Stehule
> wrote:
>
>> Hello
>>
>> postgres=# CREATE OR REPLACE FUNCTION public.reduce_dim(anyarray)
>> RETURNS SETOF anyarray
>> LANGUAGE plpgsql
>> AS $function$
>> DECLARE s $1%type;
>> BEGIN
>> FOREACH s SLICE 1 IN ARRAY $1 LO
On Wed, Nov 27, 2013 at 11:28 PM, Pavel Stehule wrote:
> Hello
>
> postgres=# CREATE OR REPLACE FUNCTION public.reduce_dim(anyarray)
> RETURNS SETOF anyarray
> LANGUAGE plpgsql
> AS $function$
> DECLARE s $1%type;
> BEGIN
> FOREACH s SLICE 1 IN ARRAY $1 LOOP
> RETURN NEXT s;
> END LOO
David Johnston writes:
> Zev Benjamin wrote
>> It appears that unnest, when called on a multi-dimensional array,
>> effectively flattens the array first. For example: ...
> Multidimensional arrays do have shortcomings in the current implementation
> of which this is one. I'm not sure, though,
2013/11/28 Mario Barcala
> And have both the same performance about searching speed? Is there any
> comparative and/or analysis?
>
I don't know about any performance analysis. I remember so wildspeed was
not merged to contrib due high large index size.
I expect similar performance.
Pavel
>
>
And have both the same performance about searching speed? Is there any
comparative and/or analysis?
Thank you,
Pavel Stehule wrote:
[...]
>
>Same functionality has pg_trgm contrib module
>
--
Mario Barcala
http://www.mario.barcala.name
--
Sent via pgsql-general mailing list (pgsql-gener
2013/11/28 Mario Barcala
> Wildspeed
Same functionality has pg_trgm contrib module
http://www.postgresql.org/docs/9.3/static/pgtrgm.html
Regards
Pavel
Hi all, I would like to ask you a question:
Is there any reason to not include Wildspeed in Postgresql contrib
section? We are using it in some projects and it is very tedious to
download and install it from source.
I read some email opinions several years ago (I don't remember where
and didn't f
My requirements can be relaxed to full text search, but the problem I had with
that approach is I have strings in Chinese, and postgres doesn't seem to support
it. Calling to_tsvector() on Chinese characters always returns an empty vector.
Hm, check your locale settings. AFAIK, somebody uses F
Thanks for the suggestions!
My requirements can be relaxed to full text search, but the problem I had
with that approach is I have strings in Chinese, and postgres doesn't seem
to support it. Calling to_tsvector() on Chinese characters always returns
an empty vector.
A separate table will defini
On Thu, Nov 28, 2013 at 12:44 AM, Teodor Sigaev wrote:
> Full-text search has this feature.
>
> # select to_tsvector('en_name=>yes, fr_name=>oui'::hstore::text) @@ 'en:*';
> ?column?
> --
> t
>
> or (index only keys)
>
> select to_tsvector(akeys('en_name=>yes, fr_name=>oui'::hstore)::tex
Hi!
Full-text search has this feature.
# select to_tsvector('en_name=>yes, fr_name=>oui'::hstore::text) @@ 'en:*';
?column?
--
t
or (index only keys)
select to_tsvector(akeys('en_name=>yes, fr_name=>oui'::hstore)::text) @@ 'en:*';
?column?
--
t
To speed up this queries yo
On Wed, Nov 27, 2013 at 6:49 PM, Albert Chern wrote:
> I have an hstore column that stores a string in several arbitrary languages,
> so something like this:
>
> "en" => "string in english", "zh" => "string in chinese", "fr" => "string in
> french"
>
> Is it possible to construct an index that can
20 matches
Mail list logo
