Re: Built-in connection pooling

[Vladimir Borodin]

> 19 апр. 2018 г., в 23:59, Andres Freund  написал(а):
> 
> I think there's plenty things that don't really make sense solving
> outside of postgres:
> - additional added hop / context switches due to external pooler
> - temporary tables
> - prepared statements
> - GUCs and other session state

+1

> 
> I think there's at least one thing that we should attempt to make
> easier for external pooler:
> - proxy authorization

I suggested it here [1] but fair amount of people argued against it in that 
thread.

[1] 
https://www.postgresql.org/message-id/98C8F3EF-52F0-4AF9-BE81-405C15D77DEA%40simply.name

--
May the force be with you…
https://simply.name

Re: Built-in connection pooling

[Vladimir Borodin]

> 18 апр. 2018 г., в 16:24, David Fetter  написал(а):
> 
> On Wed, Apr 18, 2018 at 02:52:39PM +0300, Konstantin Knizhnik wrote:
>> Yandex team is following this approach with theirOdysseus
>> (multithreaded version of pgbouncer with many of pgbouncer issues
>> fixed).
> 
> Have they opened the source to Odysseus?  If not, do they have plans to?

No, we haven't yet. Yep, we plan to do it until end on May.

> 
> Best,
> David.
> -- 
> David Fetter  http://fetter.org/
> Phone: +1 415 235 3778
> 
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
> 

--
May the force be with you…
https://simply.name

Re: [PoC PATCH] Parallel dump to /dev/null

[Vladimir Borodin]

Hi.

> 2 февр. 2018 г., в 13:25, Andrey Borodin  написал(а):
> 
>> Do folks here think that speedups would be worth it?
> I've seen backup verification via COPY TO to /dev/null in production. These 
> copies were parallelized on the side of verification script.
> Not sure this counts for feature or against it.

This sounds for feature because usage of COPY is involuntary. Having this in 
pg_dump would make our scripts for checking backups simpler.

--
May the force be with you…
https://simply.name

Re: [HACKERS] Can ICU be used for a database's default sort order?

[Vladimir Borodin]

Hi.

> 23 июня 2017 г., в 21:32, Peter Eisentraut  
> написал(а):
> 
> On 6/22/17 23:10, Peter Geoghegan wrote:
>> On Thu, Jun 22, 2017 at 7:10 PM, Tom Lane  wrote:
>>> Is there some way I'm missing, or is this just a not-done-yet feature?
>> 
>> It's a not-done-yet feature.
> 
> It's something I hope to address soon.

Will it work only for a particular database? Or for a whole cluster during 
initdb also? Any chance to get this done in 11?

--
May the force be with you…
https://simply.name