[GENERAL] Attachments

Dear all, May I humble request that only plain text attachments should be posted. This safe guards everyone against from accidental viruses been added to the email in transit. Perhaps this should have been on the CoC for everyone’s safety. Thank you.

[GENERAL] MongoDB FDW Problem.

My best for all in this list. i'm trying to use FDW for MongoDB using PostgreSQL 9.4 using pgdg yum repo: yum install postgresql94-server postgresql94-contrib mongo_fdw94 My S.O. is CentOS 9.7 64bits All is ok with Postgres. I can create extension, foreign server and foreign table. My

Re: [GENERAL] Attachments

Vick Khera writes: > (4) loses historical information when the linked document goes away. Yeah. Historically we've been very down on bug reports or patch submissions that do not provide all the requested information right in the message. This is important for archival reasons.

Re: [GENERAL] Attachments

On Tue, Feb 2, 2016 at 4:36 PM, John McKown wrote: > (3) save space on the various archives. (4) loses historical information when the linked document goes away.

Re: [GENERAL] Attachments

I prefer how the R mailing list works: No attachments of any kind and no HTML messages allowed. Just plain text email. If someone needs to supply something too large for a single email, they must put it on a Web site (such as GitHub, for example) and then include a URL for that. That is: (1) much

[GENERAL] Multiple Sequence Number for One Column p.2

Hello I've met exactly the same problem as described here http://www.postgresql.org/message-id/95862fdc-eb2e-4533-8331-d49775b0e...@f2g2000yqf.googlegroups.com . For now, I use the same solution that was presented in the response

[GENERAL] Postgres 9.5 - password for new windows user

Hello, I am brand new to Postgres 9.5 and have just installed it on my Windows OS, using the Win x86-64 installer, downloaded from: http://www.enterprisedb.com/products-services-training/pgdownload#windows I am trying to setup a new database from the Windows command prompt (run as admin) and I

Re: [GENERAL] Is it possible to select index values ?

Have you given any thought to pulling index column stats from the pg_stats view? -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.

Re: [GENERAL] handling time series data

On 02/02/2016 03:04 PM, Keith Brown wrote: By reading this, http://www.postgresql.org/message-id/7e41ba8f0908191624g4501b5f7mcbe29ad2c8139...@mail.gmail.com, I was wondering if anything has changed on the postgresql front. I have a large timeseries (2TB worth of uncompressed data). I will be

[GENERAL] Explanation of tree-generating query

I feel like I'm pretty decent with Postgres. But I saw the following query on the excellent Periscope blog. I've no idea how it works, and the various symbols involved are difficult to look up either with google or in the documentation. I believe the @ sign is probably ABS, but the <= clause in

Re: [GENERAL] Postgres 9.5 - password for new windows user

On 2/2/2016 7:14 AM, Weisenberg, Sofy Hefets wrote: I am brand new to Postgres 9.5 and have just installed it on my Windows OS, using the Win x86-64 installer, downloaded from: http://www.enterprisedb.com/products-services-training/pgdownload#windows I am trying to setup a new database from

Re: [GENERAL] MongoDB FDW Problem.

2016-02-02 20:10 GMT-02:00 : > My best for all in this list. > > i'm trying to use FDW for MongoDB using PostgreSQL 9.4 using pgdg yum > repo: yum install postgresql94-server postgresql94-contrib mongo_fdw94 > My S.O. is CentOS 9.7 64bits > > All is ok with Postgres. I

Re: [GENERAL] Multiple Sequence Number for One Column p.2

On Tue, Feb 2, 2016 at 4:28 AM, alexander wrote: > Hello > > I've met exactly the same problem as described here > http://www.postgresql.org/message-id/95862fdc-eb2e-4533-8331-d49775b0e...@f2g2000yqf.googlegroups.com > . For now, I use the same solution that was presented

Re: [GENERAL] Postgres 9.5 - password for new windows user

On 02/02/2016 07:14 AM, Weisenberg, Sofy Hefets wrote: Hello, I am brand new to Postgres 9.5 and have just installed it on my Windows OS, using the Win x86-64 installer, downloaded from: http://www.enterprisedb.com/products-services-training/pgdownload#windows I am trying to setup a new

Re: [GENERAL] Is it possible to select index values ?

On Feb 1, 2016, at 6:58 PM, David G. Johnston wrote: > You can query the statistics portion of the database to get some basic > statistics of the form mentioned. Yeah, i didn't think there would be support. The stats collector doesn't have the info that I want... it's focused on how the data

[GENERAL] handling time series data

By reading this, http://www.postgresql.org/message-id/7e41ba8f0908191624g4501b5f7mcbe29ad2c8139...@mail.gmail.com, I was wondering if anything has changed on the postgresql front. I have a large timeseries (2TB worth of uncompressed data). I will be doing some queries which change at times.

Re: [GENERAL] Explanation of tree-generating query

On 2/2/2016 3:27 PM, Guyren Howe wrote: I feel like I'm pretty decent with Postgres. But I saw the following query on the excellent Periscope blog. I've no idea how it works, and the various symbols involved are difficult to look up either with google or in the documentation. I believe the @

Re: [GENERAL] Explanation of tree-generating query

On Tue, Feb 2, 2016 at 4:27 PM, Guyren Howe wrote: > I feel like I'm pretty decent with Postgres. But I saw the following query > on the excellent Periscope blog. I've no idea how it works, and the various > symbols involved are difficult to look up either with google or in the

Re: [GENERAL] handling time series data

On 02/02/2016 03:04 PM, Keith Brown wrote: By reading this, http://www.postgresql.org/message-id/7e41ba8f0908191624g4501b5f7mcbe29ad2c8139...@mail.gmail.com, I was wondering if anything has changed on the postgresql front. I have a large timeseries (2TB worth of uncompressed data). I will be

[GENERAL] comparison between Postgresql and Microsoft SQL Server

Hi, I know there is a manual but it is quite a large and heavy document. Does anyone know of a document that compares and shows the differences between SQL Server and Postgres? That will be a substantial shortcut for me. Thanks H.F. -- Sent via pgsql-general mailing list

Re: [GENERAL] comparison between Postgresql and Microsoft SQL Server

On 2 February 2016 at 21:04, Heine Ferreira wrote: > Hi, > > I know there is a manual but it is quite a large and heavy document. > Does anyone know of a document that compares and shows the differences between > SQL Server and Postgres? > That will be a substantial

[GENERAL] Postgres 9.5 and windows and desktop heap?

Hi, Does Postgresql 9.5 still have the same limitations with the desktop heap under windows? Thanks H.F. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] comparison between Postgresql and Microsoft SQL Server

Heine Ferreira schrieb am 02.02.2016 um 09:04: > I know there is a manual but it is quite a large and heavy document. > Does anyone know of a document that compares and shows the differences between > SQL Server and Postgres? > That will be a substantial shortcut for me. I am maintaining an

Re: [GENERAL] BDR error trying to replay a invalid statement

On 2 February 2016 at 05:07, cchee-ob wrote: > I noticed that the BDR replication continually trying to replay a ddl > statement that has a syntax error. Is there anything that can be done to > skip this statement or do I need to rebuild the replicated node?

Re: [GENERAL] strange sql behavior

One more observation: not sure if it helps with the diagnosis. If I query based on time interval, not based on taxiid, the query is generally faster - I believe it is due to the way the data were loaded. Yet there is still significant performance difference: the large table seems runs faster

Re: [GENERAL] strange sql behavior

Hi Melvin, I finished reloading the small table - but the performance difference does not change at all.It seems that the query always need to read a lot more disk space to fetch fewer rows for the small table Not sure why. I ran the query you suggested - please see the results in

Re: [GENERAL] strange sql behavior

Hmm, the last index query you attached verified nothing was clustered. Just one more thing to look at. Please send the results of each of the following to a file and attach. EXPLAIN ANALYZE SELECT * FROM data2011_01 WHERE taxiid::text = 'SZB07P23'::text; EXPLAIN ANALYZE SELECT * FROM

Re: [GENERAL] strange sql behavior

please stop top posting, and quoting 100s and 100s of lines of old dreck.This list uses inline posting, and its preferred to edit out any unimportant junk from the quoted postings. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list

Re: [GENERAL] Replication Question

Thanks for the help. We need an upgrade on the DB for the solution. I checked your suggestion and it works on versions from 9.1 and above Regards On Thu, Jan 28, 2016 at 12:04 PM, Andreas Kretschmer < akretsch...@spamfence.net> wrote: > Bala Venkat wrote: > > > Hi there - >

Re: [GENERAL] Check constraints and function volatility categories

On Mon, Feb 1, 2016 at 4:48 PM, Adrian Klaver wrote: > > >> As an example of where this leads see: >> >> >> http://www.postgresql.org/message-id/7224.1452275...@sss.pgh.pa.us >> >> ​Thanks for the heads up. The good news is all machine access to >>

[GENERAL] SSD gives disappointing speed up on OSX

I have a program that inserts 50M records of about 30 bytes each, with some simple indexing, using about 5 GB of disk, layout shown below. When I run the program without the inserts, it takes a few seconds to do just the calculation part. With inserts, it takes about 90 minutes to run on my

Re: [GENERAL] SSD gives disappointing speed up on OSX

On 02/02/2016 07:32 PM, Bill Ross wrote: I have a program that inserts 50M records of about 30 bytes each, with some simple indexing, using about 5 GB of disk, layout shown below. When I run the program without the inserts, it takes a few seconds to do just the calculation part. With inserts,