On 22/06/15 20:32, Jaime Casanova wrote:
> What version of postgres is this? GIN indexes improved a lot in 9.4,
> they use less than half the space and have doubled the speed (on
> average).
>
> Now, whatever version you have; a GIN index has two data structures,
> the main one in which the index
On 23/06/15 01:30, Oleg Bartunov wrote:
> Try 9.4 and you'll surprise.
>
> 1. GIN has compression
> 2. GIN has fast scan feature.
>
Dang, and I was so happy that the Enterprise Linux we have to use here
finally had 9.1 with pg_trgm :)
But this sounds too good not to try it, I'll try to get 9.4
Is it possible to use a replication_slot for a downstream-server when setting
up cascading replication on 9.4
Leif G.
Vennlig hilsen/ Best regards
--
LEIF GUNNAR ERLANDSEN
Senior Database Consultant
BASEFARM | Nydalen Allé 37a | 0484 Oslo | Norway
Phone: +47 4000 4100 | Mobile: +47 9
On Tue, Jun 23, 2015 at 8:18 PM, Leif Gunnar Erlandsen
wrote:
> Is it possible to use a replication_slot for a downstream-server when
> setting up cascading replication on 9.4
Yes. Just be careful that replication slot data is not included in a
base backup.
--
Michael
--
Sent via pgsql-genera
>Fra: Michael Paquier
>Sendt: 23. juni 2015 13:32
>On Tue, Jun 23, 2015 at 8:18 PM, Leif Gunnar Erlandsen
> wrote:
>> Is it possible to use a replication_slot for a downstream-server when
>> setting up cascading replication on 9.4
>Yes. Just be careful that replication slot data is not incl
Albe Laurenz wrote:
>
> Maybe it has something to do with this OpenSSL bug:
> http://rt.openssl.org/Ticket/Display.html?id=3712&user=guest&pass=guest
>
> Basically, OpenSSL fails to handle application data messages during
> renegotiation.
>
> I have only encountered that when using other SSL libr
Is it possible to use a replication_slot for a downstream-server when setting
up cascading replication on 9.4
Leif G.
Piotr Gackiewicz writes:
> Yep, that's it :
> $ psql -h localhost -c "SET ssl_renegotiation_limit='3kB'; SELECT
> repeat('0123456789', 1800);"
> SSL error: unexpected message
> connection to server was lost
> psql and server share same openssl library on the same host, of course.
Red Hat have
Piotr Gackiewicz writes:
> $ psql -h localhost -c "SET ssl_renegotiation_limit='3kB'; SELECT
> repeat('0123456789', 1800);"
> SSL error: unexpected message
> connection to server was lost
BTW, are you using any nondefault SSL settings? Because I can't reproduce
the failure you show. In my test
I wrote:
> Piotr Gackiewicz writes:
>> $ psql -h localhost -c "SET ssl_renegotiation_limit='3kB'; SELECT
>> repeat('0123456789', 1800);"
>> SSL error: unexpected message
>> connection to server was lost
> BTW, are you using any nondefault SSL settings? Because I can't reproduce
> the failure yo
Hi. My company have servers that run postgres for storing some logs and
serving django web interfaces for management of the server itself. In the
last days some servers stopped serving the web interface, and syslog show
this error:
Jun 23 04:40:19 django-1 postgres[8790]: [3-1] FATAL: remaining c
On 6/23/2015 10:58 AM, Bruno Hass de Andrade wrote:
*I really don't know what is happening, why postgres hang and didn't
close the connections. This django web interface is used only for
management and viewing logs, most server have two users only.*
*
*
*I've sent this email just to know if one
On 2015-06-22 13:32:23 +, Leif Gunnar Erlandsen wrote:
> Is it possible to use a replication_slot for a downstream-server when setting
> up cascading replication on 9.4
yes.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
What are peoples experiences with either/both, pluses/minuses?
Ted
I use odbc in a windows environment.
No complaints, can do inserts, select, updates, joins, execute stored
procedures
with little fuss...more than fast enough for my purposes.
There are some issues with 32/64 bit odbc depending on your relative
OS..as far as installing the correct odbc version. T
On 6/23/2015 3:56 PM, Ted Toth wrote:
What are peoples experiences with either/both, pluses/minuses?
ODBC adds a whole layer of obfuscation which, IMHO, if you know you're
only dealing with PostgreSQL, is infuriating.
I'd rather program the native API, its just much cleaner and simpler,
un
- Original Message -
From: Bret Stern
I use odbc in a windows environment.
No complaints, can do inserts, select, updates, joins, execute stored
procedures
with little fuss...more than fast enough for my purposes.
There are some issues with 32/64 bit odbc depending on your relat
On Mon, Jun 22, 2015 at 6:53 PM, Jerry Sievers
wrote:
> Suresh Raja writes:
>
> > Hi All:
> >
> > Does postgresql support schema analyze. I could not find
> > analyze schema anywhere. Can we create a function to run
> > analyze and reindex on all objects in the schema. Any
> >
18 matches
Mail list logo
