Re: [GENERAL] Postgres 9.6 fails to start on VMWare

On Mon, 23 Oct 2017 09:14:18 +0100, Martin Moore wrote: >Same server. I tried a few times. > >I didn’t move the db separately, but did a ‘dd’ to copy the disk >to an imagefile which was converted and loaded into VMWare. If you copied the boot device that way while the system was running, then yo

Re: [GENERAL] Speed of conversion from int to bigint

Tomas's suggestion definitely is the better if you're altering the type of a single column. If you need to make more extensive changes to the table structure, copying usually is the better way to go. George -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Speed of conversion from int to bigint

On Wed, 27 Sep 2017 09:08:25 +0100, Jonathan Moules wrote: >Hi, >(Postgres 9.5 and 9.6) >We have a table of about 650million rows. It's a partitioned table, >with two "child" tables. We want to change its primary key type >from int to bigint while retaining the current values. > >We're using this

Re: [GENERAL] VM-Ware Backup of VM safe?

On Fri, 22 Sep 2017 16:14:23 +0200, "Klaus P. Pieper" wrote: >I am aware that VSS is purely Windows, and your comment about VSS aware >application is true. Backup programs / VM managers like Data Protection >Manager trigger these applications to put the files into a safe state >prior to the snaps

Re: [GENERAL] VM-Ware Backup of VM safe?

On Wed, 20 Sep 2017 20:24:05 +0200, "Klaus P. Pieper" wrote: >> Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- >> ow...@postgresql.org] Im Auftrag von George Neuner >> >> But VSS is needed only to copy VM files *while* they are in >> us

Re: [GENERAL] VM-Ware Backup of VM safe?

On Wed, 20 Sep 2017 17:15:36 +0200, "Klaus P. Pieper" wrote: >> -Ursprüngliche Nachricht- >> Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- >> ow...@postgresql.org] Im Auftrag von Thomas Güttler >> Gesendet: Mittwoch, 20. September 2017 10:03 >> An: pgsql-general@postgresq

Re: [GENERAL] VM-Ware Backup of VM safe?

On Wed, 20 Sep 2017 10:03:15 +0200, Thomas Güttler wrote: >We run a PostgreSQL 9.6 server in a virtual machine. >The virtual machine is managed by the customer. >He does backup the VM. > >Is this enough, is this safe? It is "safe" if the VM is shut down first or if the backup is by copying a poi

Re: [GENERAL] looking for a globally unique row ID

On Thu, 14 Sep 2017 17:02:05 -0500, Merlin Moncure wrote: >... With sequences, the database *guarantees* that the >identifier is unique with no exceptions; there never will be a unique >value. Can you give a hypothetical example of how you think they >wouldn't work? Jumping in here, but a month

Re: [GENERAL] looking for a globally unique row ID

On Thu, 14 Sep 2017 09:45:59 +0200, Rafal Pietrak wrote: >Hello everybody, > >Can anybody help me find a way to implement an ID which: > >1. guarantees being unique across multiple tables. > >2. guarantees its uniqueness not only during INSERT, but also during the >lifetime of the database/applic

Re: [GENERAL] equivalent for md5, clobs and varchar2 list

On Thu, 14 Sep 2017 00:01:09 +, Peter Koukoulis wrote: >is there an equivalent of a odcivarchar2list in PostgreSQL. I'm running the >code in Oracle 11gr2. >I know that the equivalent of dbms_crypto. hash( " " ,2) is md5(), but I >cannot find anything similar to odcivarchar2list? >I am cons

Re: [GENERAL] PostgreSQL COPY Statement Error On Linux

On Tue, 12 Sep 2017 11:30:02 +0100, Osahon Oduware wrote: >I am trying to utilize the "COPY" statement below to copy a .CSV file to a >table in a PostgreSQL database.: >*COPY .() FROM >'\\shared\network\path\to\csv\test.csv' DELIMITER ',' CSV HEADER;* > >This works with a PostgreSQL database

Re: [GENERAL] pgadmin - import a CSV with nulls?

On Thu, 31 Aug 2017 13:20:27 -0700, "David G. Johnston" wrote: >On Thu, Aug 31, 2017 at 1:04 PM, George Neuner wrote: > >> Does anyone know a way to do this reliably? > >?The psql "\copy" meta-command should be capable of doing what you desire. > >Da

[GENERAL] pgadmin - import a CSV with nulls?

Hi all, I'm trying to move some data between databases that have different structure, and I'm stuck on how to import a CSV file that contains nulls. Both databases are remote, so COPY is not an option - I don't have shell or filesystem access to the servers. pgAdmin 4 seems useless: it neither

Re: [GENERAL] Porting libpq to QNX 4.25

On Mon, 21 Aug 2017 13:27:56 -0300, marcelo wrote: >Is there a libpq porting to QNX 4.25? I just tried to compile one of the >modules, but was rejected because the QNX's standard library have not an >Int64 type. >TIA QNX 4.25 is very old (mid 90's) - its toolchain compiler would be C90 unless

Re: [GENERAL] Where is pg_hba.conf

On Sun, 13 Aug 2017 10:55:00 -0400, Igor Korot wrote: >Also, I presume that the address in this file is the address of the >machine where the server is located, not the address from where the >connection is initiated. No. The addresses / network segments in the file specify from where the clien

Re: [GENERAL] Partitioning

On Tue, 25 Jul 2017 18:21:43 +0530, Krithika Venkatesh wrote: >I have a table that is partitioned on a numeric column (ID). > >Partitioning works when I query the table with no joins. > >SELECT * FROM TABLE A a WHERE ID IN (SELECT ID FROM TABLE B b WHERE >CREATED_TS = CURRENT_TIMESTAMP) > >Partit

Re: [GENERAL] pg_upgrade --link on Windows

On Fri, 9 Jun 2017 07:24:03 -0700, Adrian Klaver wrote: >https://msdn.microsoft.com/en-us/library/windows/desktop/aa365006(v=vs.85).aspx > >Seems to me the difference is hard links point to file, junctions to >directories. You can make either hard links or symlinks to files. Junctions are dis

Re: [GENERAL] pg_upgrade --link on Windows

On Fri, 9 Jun 2017 10:07:24 -0400, Bruce Momjian wrote: >On Fri, Jun 9, 2017 at 12:00:56PM +0200, Arnaud L. wrote: >> Hi >> >> The pg_upgrade documentation for PostgreSQL 9.6 states that --link will use >> junction points on Windows. >> Shouldn't it rather user hard-links ? >> If I'm not mistak

Re: [GENERAL] logical replication in PG10 BETA

On Tue, 23 May 2017 15:15:46 +, Igor Neyman wrote: >Interestingly, when I add this line to pg_hba.conf: > >localall all md5 > >Postgres is not starting with the following error in the log file: > >2017-05-23 11:02:10.397 EDT [4796] LOG: local connections are not sup

Re: [GENERAL] psql: do/should we document that argument and option specification order doesn't matter?

On Thu, 11 May 2017 16:15:43 -0700, "David G. Johnston" wrote: >I don't know if this applies anywhere else but I just stumbled across the >fact that our psql documentation is imprecise: > >https://www.postgresql.org/docs/current/static/app-psql.html > >psql [option...] [dbname [username]] > >It d

Re: [GENERAL] Top posting....

On Thu, 11 May 2017 13:43:52 -0400, Tom Lane wrote: >... The point of quoting previous messages is not to replicate >the entire thread in each message; we have archives for that. The point >is to *briefly* remind readers what it is that you're responding to. >If you can't be brief, you are disre

Re: [GENERAL] Python versus Other Languages using PostgreSQL

On Mon, 8 May 2017 14:26:02 -0700, Paul Hughes wrote: >Hello, > >I noticed that most of the largest web platforms that use PostgreSQL as >their primary database, also use Python as their primary back-end language. >Yet, according to every benchmark I could find over the last couple of >years, bac

Re: [GENERAL] full text search on hstore or json with materialized view?

On Thu, 20 Apr 2017 07:56:18 -0700, Rj Ewing wrote: >On Wed, Apr 19, 2017 at 6:44 PM, George Neuner wrote: >> >> If you can restrict the FTS query to certain keys: >> >> SELECT id FROM mytable >> WHERE tsquery( ... ) @@ to_tsvector(v) >>

Re: [GENERAL] full text search on hstore or json with materialized view?

On Thu, 20 Apr 2017 08:50:31 -0700, Rj Ewing wrote: >On Wed, Apr 19, 2017 at 9:55 PM, George Neuner wrote: > >> ... Since you are *testing* with 1M records (that >> create 44M k:v shards), I am assuming you will need to deal with much >> more than that in deployment. A

Re: [GENERAL] full text search on hstore or json with materialized view?

On Thu, 20 Apr 2017 00:55:48 -0400, George Neuner wrote: Doh! > SELECT count(distinct s.id) >FROM samples_lg_txt AS s >JOIN keys AS k ON k.id = s.key >WHERE (k.name = 'key1' AND s.tsv @@ to_query('value1') > OR (k.name = &

Re: [GENERAL] full text search on hstore or json with materialized view?

On Wed, 19 Apr 2017 16:28:13 -0700, Rj Ewing wrote: >okay, messing around a bit more with the secondary k,v table it seems like >this could be a good solution.. > >I created a keys table to hold the 63 key values, then I dropped and >recreated the secondary table, using a FK referencing the keys

Re: [GENERAL] full text search on hstore or json with materialized view?

Please don't top post. https://en.wikipedia.org/wiki/Posting_style#Placement_of_replies https://en.wikipedia.org/wiki/Posting_style#Choosing_the_proper_posting_style >> On Tue, 18 Apr 2017 14:38:15 -0700, Rj Ewing >> wrote: >> >> > : >> >An idea that has come up is to use a materialized view

Re: [GENERAL] Recover corrupted data

On Wed, 19 Apr 2017 13:25:41 -0300, Alexandre wrote: > : >But there is no solution for [file corruption]? The only solutions are to guard against it: make frequent backups and make use of safety mechanisms in Postgresql and in the OS. Postgresql logs (WAL) intended changes to the database bef

Re: [GENERAL] full text search on hstore or json with materialized view?

On Tue, 18 Apr 2017 14:38:15 -0700, Rj Ewing wrote: >I am evaluating postgres for as a datastore for our webapp. We are moving >away from a triple store db due to performance issues. > >Our data model consists of sets of user defined attributes. Approx 10% of >the attributes tend to be 100% fille

Re: [GENERAL] browser interface to forums please?

On Wed, 5 Apr 2017 14:44:55 -0700, "David G. Johnston" wrote: >A mailing list configuration that will automatically add on the OP to any >email in a message thread lacking the OP would work-around those list >respondents who would use "Reply" instead of "Reply All". Keeping track of >all respond

Re: [GENERAL] browser interface to forums please?

On Wed, 5 Apr 2017 10:57:23 -0700, "Joshua D. Drake" wrote: >Stack Overflow (as an example) is a collaboration platform. Stack >understands the problem and is very, very good at solving it. It is why >they are successful. Stack Overflow *is* successful ... at driving people away because any co

Re: [GENERAL] browser interface to forums please?

On Wed, 5 Apr 2017 11:39:17 -0700, John R Pierce wrote: >On 4/5/2017 11:30 AM, George Neuner wrote: >> This makes it difficult to follow a discussion via email, and Google's >> list handling is flawed - it sometimes breaks the underlying list >> threading [while keeping

Re: [GENERAL] browser interface to forums please?

On Wed, 5 Apr 2017 12:05:39 -0500, John McKown wrote: > : >I don't mind an "archive" web site which records all of the >emails. And it it properly threads them, that is even better. I have that >on a number of my lists. And you can even post through them. The post goes >directly to the web site,

Re: [GENERAL] browser interface to forums please?

On Wed, 5 Apr 2017 09:31:59 -0700, Adrian Klaver wrote: >On 04/05/2017 09:17 AM, Magnus Hagander wrote: > >> This has been tried a number of times. I'ts been a couple of years since >> I last saw one, but multiple people have set up forums, either mirrored >> or not. They have all died because of

Re: [GENERAL] Advise on primary key for detail tables (OS: Raspberry Pi)

On Wed, 5 Apr 2017 18:04:39 +0300, Ertan Küçüko?lu wrote: >I have a project which will be mainly built on Raspberry Pi and some parts >on Windows. > >I must have a PostgreSQL 9.4.10 running on Raspberry Pi and another >PostgreSQL running on Windows. Though, there is still a possibility that >Wind

Re: [GENERAL] spin locks and starvation

On Mon, 3 Apr 2017 11:40:29 +0200, Tom DalPozzo wrote: >I saw that postgresql implementation makes big use of spin locks. >I was wondering if I should be concerned about possible starvation problem >because I looked around and couldn't find an absolute answer about if linux >spinlocks guarantee p

Re: [GENERAL] browser interface to forums please?

On Sat, 25 Mar 2017 16:37:00 +, Tim Clarke wrote: >On 25/03/17 16:25, David G. Johnston wrote: >> >> One constraint is that the current email based flow cannot be >> disrupted. Adding on a fully integrated forum-like GUI does have some >> demand. I don't see it being met if the it needs to

Re: [GENERAL] Postgres goes to auto recovery mode after system restart(check this draft)

On Mon, 20 Mar 2017 12:05:01 +0100, Karsten Hilbert wrote: >On Mon, Mar 20, 2017 at 06:48:36AM -0400, George Neuner wrote: > >> Windows informs all processes that it is shutting down (or entering >> sleep, or waking up, etc.), but the notifications take different forms >&

Re: [GENERAL] Postgres goes to auto recovery mode after system restart(check this draft)

On Mon, 20 Mar 2017 11:04:35 +0100, Francisco Olarte wrote: >Manoj: > >On Mon, Mar 20, 2017 at 10:55 AM, Manojkumar S > wrote: >> I started Postgres from command line using pg_ctl.exe and restarted my >> windows machine. Whenever I start postgres again after machine restart, >> postgres goe

Re: [GENERAL] psql - looking in wrong place for socket

On Fri, 17 Mar 2017 10:31:16 -0400, Steve Clark wrote: >Hmm... maybe you missed the fact I am running CentOS 6. It appears >8.20 is the latest official release. I'm running 9.5.5 on Centos 6.8 - no problems at all. Go into /etc/yum.repos.d/CentOS-Base.repo, and add the line exclude=postg

Re: [GENERAL] DISTINCT vs GROUP BY - was Re: is (not) distinct from

Hi David, On Sat, 4 Mar 2017 02:32:48 +1300, David Rowley wrote: >On 3 March 2017 at 18:26, George Neuner wrote: >> I know most people here don't pay much - or any - attention to >> SQLServer, however there was an interesting article recently regarding >> significa

[GENERAL] DISTINCT vs GROUP BY - was Re: is (not) distinct from

On Wed, 01 Mar 2017 11:12:29 -0500, Tom Lane wrote: >This is a great example of "select distinct" being used as a band-aid >over a fundamental misunderstanding of SQL. It's good advice to never use >"distinct" unless you know exactly why your query is generating duplicate >rows in the first plac

Re: [GENERAL] Means to emulate global temporary table

On Wed, 11 Jan 2017 15:23:10 -0800, John R Pierce wrote: >On 1/11/2017 2:07 PM, Ian Lewis wrote: >> I am working on porting from an SQL Anywhere server that has support >> for general temporary tables. It appears that PostgreSQL does not have >> such support. > >postgres temporary tables are ei

Re: [GENERAL] Not clear how to switch role without permitting switch back

On Mon, 9 Jan 2017 23:05:47 -0800, Guyren Howe wrote: >For my Love Your Database Project: > >https://medium.com/@gisborne/love-your-database-lydb-23c69f480a1d#.8g1ezwx6r > > >I’m trying to see how a typical web develop

Re: [GENERAL] journaling / time travel

Coming late to this, but ... On Mon, 19 Sep 2016 17:48:20 +0200, Willy-Bas Loos wrote: >The use case of legal disputes being fought with our data as evidence and >digging up the exact data from a certain point of time never occurred in >those 10 years, and it is unlikely that it ever will. >But

Re: [GENERAL] UUIDs & Clustered Indexes

On Tue, 30 Aug 2016 09:40:33 -0700, "Mike Sofen" wrote: >From: Tom Lane Sent: Tuesday, August 30, 2016 7:16 AM > >>Do you actually *need* UUID keys, and if so why? A plain old bigint column >>is smaller, cheaper to index, and the natural mechanism for generating it >>(ie a sequence) will tend t

Re: [GENERAL] PostgreSql Doubts

On Fri, 20 May 2016 09:19:08 -0500, John McKown wrote: >I don't know much about FireBird. I (not a lawyer) think it has a very good >license. One interesting thing is that it says that it can run as a >"server", like PostgreSQL, or "embedded", like SQLite. But I can't really >figure out how the "

Re: [GENERAL] PG wire protocol question

On Sat, 14 May 2016 21:58:48 +0200, Boszormenyi Zoltan wrote: >Hi, > >it was a long time I have read this list or written to it. > >Now, I have a question. This blog post was written about 3 years ago: >https://aphyr.com/posts/282-jepsen-postgres > >Basically, it talks about the client AND the se

Re: [GENERAL] NULL concatenation

On Fri, 13 May 2016 08:45:46 +0530, Sridhar N Bamandlapally wrote: >we need simple concatenation of all variables(which values may come NULL or >valid-values based on functional process), > >coalesce is different functionality As Pavel suggested, concat will work, but it swallows NULLs leaving n

Re: [GENERAL] Using both ident and password in pg_hba.conf

On Tue, 10 May 2016 09:50:10 -0400, "D'Arcy J.M. Cain" wrote: >On Mon, 09 May 2016 18:15:16 -0400 >Tom Lane wrote: >> > I did think of that but how do I define that in pg_hba? The host >> > field only specifies the remote IP, not the local one. >> >> Right, but you'd be using it essentially as

Re: [GENERAL] PostgreSQL and Windows 10 exception 0xC0000018

On 5/5/2016 1:17 PM, Moreno Andreo wrote: Il 05/05/2016 18:40, George Neuner ha scritto: Otherwise: if Postgresql is loading any non-standard extensions, I would try to check those DLLs. If you have a recent Visual Studio handy, run "link /dump /headers " on the DLLs and look for an

Re: [GENERAL] PostgreSQL and Windows 10 exception 0xC0000018

Disclaimer: I do not run Postgresql on Windows. On Thu, 5 May 2016 14:39:25 +0200, Moreno Andreo wrote: >a strange error is happening to some of our customers. >They all have a Windows 10 installation on their machines with >our application and, of course, PostgreSQL 9.1 installed >(migrat

Re: [GENERAL] Thoughts on "Love Your Database"

On Tue, 3 May 2016 23:11:06 -0500, Guyren Howe wrote: >I've long been frustrated with how most web developers I meet >have no idea how to use an SQL database properly. I think I'm >going to write a book called Love Your Database, aimed at web >developers, that explains how to make their apps be

Re: [GENERAL] intermittent issue with windows 7 service manager not able to correctly determine or control postgresql 9.4

Disclaimer: My comments here are generic to Windows services. I don't run Postgresql on Windows and I have no idea how it is implemented. On Sun, 1 May 2016 03:35:44 +0100, Tom Hodder wrote: >I've got several machines running windows 7 which have postgresql 9.4 >installed as a service, a

Re: [GENERAL] Columnar store as default for PostgreSQL 10?

On Mon, 25 Apr 2016 21:48:44 -0400, Adam Brusselback wrote: >>It is not difficult to simulate column store in a row store system if >>you're willing to decompose your tables into (what is essentially) >>BCNF fragments. It simply is laborious for designers and programmers. > >I could see a true c

Re: [GENERAL] Columnar store as default for PostgreSQL 10?

On Thu, 21 Apr 2016 09:08:22 -0700, "David G. Johnston" wrote: >?I have little experience (and nothing practical) with columnar store but >at a high level I don't see the point. At the high level, it's about avoiding fetching data you don't need. In a row store system, in general you must fetc

Re: [GENERAL] Freezing localtimestamp and other time function on some value

On Tue, 12 Apr 2016 13:50:11 +0300, Alex Ignatov wrote: >Is there any method to freeze localtimestamp and other time function value. >Say after freezing on some value sequential calls to these functions >give you the same value over and over again. >This is useful primarily for testing. > >In o

Re: [GENERAL] Error: insufficient data in the message

Replying to Adrian because I'm not seeing some of Ranier's posts. >On 03/18/2016 08:49 AM, Ranier VF wrote: > >> Would be possible, example code in C, to format BIGINT >> param with msvc 32 bits compiler? >> > Subject: Re: [GENERAL] Error: insufficient data in the message >> > To: ranier_...@h

Re: [GENERAL] Windows performance

On Fri, 12 Feb 2016 14:43:55 -0800, John R Pierce wrote: >On 2/12/2016 2:28 PM, George Neuner wrote: >> In Linux the distinction between a "workstation" and a "server" is >> largely a matter of system configuration. Windows "desktop" and >> &q

Re: [GENERAL] Windows performance

On Fri, 12 Feb 2016 15:37:37 +, "Sterpu Victor" wrote: >Why is Postgres so slow on Windows compared to linux? >Can I do something to match the performance? >I have 2 servers: >- one is Windows 8, CPU XEON, 8 CORES, 32G of RAM - my test query runs >in 17 seconds >- the other is Linux CPU XEO

Re: [GENERAL] long transfer time for binary data

On Fri, 22 Jan 2016 22:05:24 +0100, Johannes wrote: >Thanks for explanation. Im writing a client software in java/jdbc. Most >images are in jpeg format. Some have high quality, most medium. Unfortunately I'm not terribly conversant in Java ... I can read/understand it, but I rarely write any.

Re: [GENERAL] long transfer time for binary data

On Wed, 20 Jan 2016 22:29:07 +0100, Johannes wrote: >I noticed transferring a large object or bytea data between client and >server takes a long time. >For example: An image with a real size of 11 MB could be read on server >side (explain analyze) in 81ms. Fine. > >But on client side the result w

Re: [GENERAL] Shared system resources

Hi Oleg, On Wed, 23 Dec 2015 07:07:31 -0600, oleg yusim wrote: >May we run into situation, when attacker dumps memory and analyses it for >valuable content, instead of reserving it for own process, where it would >be zeroed? My understanding, it is a possibility. Does kernel have any >safeguard

Re: [GENERAL] Shared system resources

On Tue, 22 Dec 2015 23:21:27 +, David Wilson wrote: >On Linux the memory pages of an exiting process aren't sanitized at >exit, however it is impossible(?) for userspace to reallocate them >without the kernel first zeroing their contents. Not impossible, but it requires a non-standard kernel

Re: [GENERAL] Permissions, "soft read failure" - wishful thinking?

On Mon, 14 Dec 2015 09:55:02 -0800, Benjamin Smith wrote: >Is there a way to set PG field-level read permissions so that a deny doesn't >cause the query to bomb, but the fields for which permission is denied to be >nullified? How about using encryption? pgp_sym_decrypt() returns null if any

Re: [GENERAL] using a postgres table as a multi-writer multi-updater queue

On Mon, 30 Nov 2015 23:07:36 -0500, "Steve Petrie, P.Eng." wrote: >Instead of using a DELETE command to destroy the row (and a >resource-intensive AUTOVACUUM / VACUUM process to reclaim the storage >space), why not instead, simply mark that session management row as "free" >(with an UPDATE comman

Re: [GENERAL] using a postgres table as a multi-writer multi-updater queue

On Sun, 29 Nov 2015 05:02:58 -0500, "Steve Petrie, P.Eng." wrote: >I should have clarified, that I use the the term "fuzzy" to refer to the >probability mechanism, that hooks a small burst of session row deletion >activity, to each one of a randomly-selected portion (presently 1/5) of the >HTTP r

Re: [GENERAL] using a postgres table as a multi-writer multi-updater queue

On Sun, 29 Nov 2015 05:04:42 -0500, "Steve Petrie, P.Eng." wrote: >"George Neuner" wrote in message >news:kaed5btl92qr4v8ndevlgtv0f28qaae...@4ax.com... > >> My vote for an email client would be Thunderbird. It runs on XP or >> higher and you can impo

Re: [GENERAL] using a postgres table as a multi-writer multi-updater queue

On Wed, 25 Nov 2015 23:39:39 -0500, "Steve Petrie, P.Eng." wrote: >My stupid email client software (Microsoft Outlook Express on Win XP) >refuses to respect its own "Reply" option settings for inline reply text. >I've been looking for a replacement email client but so far without success.) With

Re: [GENERAL] using a postgres table as a multi-writer multi-updater queue

On Wed, 25 Nov 2015 23:39:39 -0500, "Steve Petrie, P.Eng." wrote: >Now, I'm reading in this forum that in fact, postgres does not efficiently >automatically recycle storage space released by row DELETion. Yes and no. Space resulting from deleted rows is not given back to the OS unless you pe

[GENERAL] partitioned tables

Hi all, I've been using Postgresql (9.3) for a while, but I'm new to partitioned tables. 1. I have noticed that when the partition trigger function returns NULL (to stop operation on the parent table), the operation always reports no (zero) rows affected - even when rows have been affected. Th

[GENERAL] Off Topic: Anybody reading this via news.gmane.org?

Just wondering if anyone else reads this list via gmane and also is having problems? I follow several lists via gmane and a few days ago all my posts started being rejected - no authorization email, just an immediate "you are not allowed to post" error. Then 2 days ago, I also lost read a

Re: [GENERAL] PostgreSQL Portable

Hi Craig, On Fri, 12 Sep 2014 11:33:55 +0800, Craig Ringer wrote: >On 09/11/2014 03:16 PM, George Neuner wrote: >> >> If the driver permits it and you [or your users] can be trusted to >> perform a safe unmount via the OS *before* disconnecting the device, >> then y

Re: [GENERAL] PostgreSQL Portable

On Wed, 10 Sep 2014 14:19:45 -0700, John R Pierce wrote: >also, Windows disables writeback caching on external disks, this will >greatly slow down update transactions. Not exactly. By default, write caching is disabled for external drives to support quick disconnect, i.e. yanking the device wi