Re: [GENERAL] PgPool or alternatives

written for Oracle. Simon On 21/01/2017 20:09, Stephen Frost wrote: Simon, * Simon Windsor (simon.wind...@cornfield.me.uk) wrote: My employer wants to move from an in house Oracle solution to a cloud based Postgres system. The system will involve a number of data loaders running 24x7 feeding

[GENERAL] PgPool or alternatives

? Simon -- Simon Windsor Eml: simon.wind...@cornfield.me.uk Tel: 01454 617689 Mob: 0755 197 9733 “There is nothing in the world that some man cannot make a little worse and sell a little cheaper, and he who considers price only is that man's lawful prey.” -- Sent via pgsql-general mailing

Re: [GENERAL] Large Objects and and Vacuum

regularly. Simon -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: 02 January 2012 11:18 To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Large Objects and and Vacuum On 12/30/11 3:54 PM, Sim

[GENERAL] Large Objects and and Vacuum

another method of scanning postgres tables, moving active blocks and releasing store back to the OS? Failing this, I can see an NFS mount being required. Simon Simon Windsor Eml: <mailto:simon.wind...@cornfield.org.uk> simon.wind...@cornfield.org.uk Tel: 01454 617689 Mob:

[GENERAL] Vacuum and Large Objects

e for number formatting lc_time = 'en_GB.UTF-8' # locale for time formatting default_text_search_config = 'pg_catalog.english' Besides running VACUUM FULL pg_largeobject;, is there a way I can get autovacuum to start and clear this up? All the b

[GENERAL] Postgres performance and the Linux scheduler

Hi Can the performance of Postgres be boosted, especially on busy systems, using the none default DEADLINE Scheduler? Simon Simon Windsor Eml: <mailto:simon.wind...@cornfield.org.uk> simon.wind...@cornfield.org.uk Tel: 01454 617689 Mob: 07590 324560 "There is

[GENERAL] Postgres or Greenplum

to split the data into separate sequential files that can be accessed by multiple writers/reader processes? If so, what was the conclusion? Finally, thanks for all the good work over the years! Simon Simon Windsor Eml: <mailto:simon.wind...@cornfield.org.uk> simo

[GENERAL] PIVOT tables and crosstab

Hi Are there any plans to embed crosstab within the main release of Postgres, rather than as a Contrib component. Also, are there plans to enhance crosstab along the lines of Oracle 11g of pivot command? All the best Simon -- Simon Windsor Eml: simon.wind...@cornfield.me.uk Tel: 01454 617689

[GENERAL] Performance of views

. Am I right to avoid to VIEWS within application code? Simon -- Simon Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

[GENERAL] pg_hba problem

ess to the postgres account? Simon -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Postgres 8.1

Hi   Has a roadmap and timescale been released for Postgres 8.1?   All the best   Simon   Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599  

[GENERAL] OT: phpPgAdmin

I need? I have tried it out with 'SELECT', on all tables/views, being granted to the user, but when I try and look at processes, I get a list of values when trying to look at the SQL. Any ideas? Thanks Simon -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07

[GENERAL] Postgres 8 and Slony-1

Hi Any news when Postgres 8 will be released? Also, are there any plans to include Slony with it, as part of the same source download, or as part of a group 'matched' source files/rpms/dpkgs etc? Thanks All Simon -- Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07

Re: [GENERAL] coalesce and nvl question

tgres that replaces Empty strings, as against a NULL value. Simon On Wed, 2004-06-23 at 18:05, Mike Mascari wrote: > Simon Windsor wrote: > > Hi > > > > Is there a standard postgres method of replacing empty strings. > > > > In Oracle, nvl handles nulls and empty

[GENERAL] coalesce and nvl question

AGE plpgsql; Thanks Simon -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Mailscanner thanks transtec Computers for their support. --

[GENERAL] WAL details

easily. How do I achieve this with Postgres? Simon -- Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Mailscanner thanks transtec Computers for their support

[GENERAL] How do I change column details

, created the new one, copied the data into it and dropped the renamed column. Is the only way? All the best Simon -- Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be

[GENERAL] md5 calls

  Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599  

[GENERAL] Case of strings

must I add upper()/lower() to force the case and then make string tests?   Ie Where upper(A)=upper(‘String’)   Many thanx   Simon   Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599   -- This message has been scanned for viruses and dangerous content by

[GENERAL] Replication options

advise suitable methods (ie Replicator, dbexperts, GBORG etc) for MASTER-MASTER and MASTER-SLAVE(Multiple) replication.   Many thanx   Simon   Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599  

[GENERAL] Replication options

provide master-master and master-slave replication Simple to configure and maintain   Many Thanx   Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599   -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed

[GENERAL] Moving from MySQL

Hi   I am sorry for mailing this list directly, but I am planning to migrate a web application from MySQL to Postgres. I am aware of a number of applications to help in this process, ie my2pg, etc. The biggest stumbling block I face is replication.   What facilities exist within Postgres to r