Re: [GENERAL] 9.4+ partial log-shipping possible?

this helps it would be possible to separate them by tablespaces. Regards Sven -- Mike -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] regexp_replace to remove sql comments

is */ <-- cannot get a regex to do this FROM to_clean ORDER BY q Im now thinking it may be better to do in a pgsql function as I think if the comments are in queries then they need to be ignored. Has anyone done anything like this? Thanks, Mike. -- Sent via pgsql-general mailing list

Re: [GENERAL] regexp_replace to remove sql comments

', 'g') , '\s+', ' ', 'g')) as q FROM public.pg_stat_statements WHERE dbid IN (SELECT oid FROM pg_database WHERE datname = current_database()) order by query Thanks again, Mike. On 28/10/2015 22:43, Marc Mamin wrote: ', '\/\*.+\*\/

[GENERAL] Performance Question - Table Row Size

fields at a given time but each row contains significantly more data that are not being queried at the time. Thanks, Mike ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] One Large Table or Multiple DBs?

or each of their accounts? Which one is more efficient? My guess was in one large DB with large tables. Thank you, Mike ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Performance Question - Table Row Size

other tables and relate the tables together. He was arguing storing binary data on a table, even though, it is not queried slows down other queries and with this. Thanks again, Mike ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [GENERAL] How to Cluster an Index live?

According to PostgreSQL.org TODO: CLUSTER * -Make CLUSTER preserve recently-dead tuples per MVCC requirements * Automatically maintain clustering on a table This might require some background daemon to maintain clustering during periods of low usage. It might also require tables to

Re: [GENERAL] How to Cluster an Index live?

Look for it in 8.3: http://archives.postgresql.org/pgsql-patches/2006-08/msg00124.php ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] message contents do not agree with length in message type "T"

from server while idle message type 0x44 arrived from server while idle message type 0x43 arrived from server while idle message type 0x5a arrived from server while idle --snip-- Thanks for your time, Mike

Re: [GENERAL] message contents do not agree with length in message type "T"

Thanks Tom, That's definitely it- I've got a global database object that's used throughout my application, it looks like I missed one crucial mutex lock in the database code. Thanks again, Mike -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Monday, Ma

[GENERAL] advisory locks in stored procedures

can use a select .. for update, but I'd prefer to use advisory locks if possible. Do advisory locks work inside functions? Could it be related somehow to PERFORM instead of SELECT? Any thoughts would be greatly appreciated. Cheers, Mike

Re: [GENERAL] Select Cast Error

rom 11 for 2)). That is the reason for the error message you are seeing. I don't quite get how you are expecting to return 4 from 0004 instead of 3 from 0003 based on the statement above. Mike > > > List below is a better idea of what my table looks like and the result > I

Re: [GENERAL] planer picks a bad plan (seq-scan instead of index)

Have you run analyze on all the three tables since creating the database? What On Thu, 2006-11-09 at 02:31 +0100, Thomas H. wrote: > hi list. > > as soon as i left-join an additional table, the query takes 24sec instead of > 0.2sec, although the added fields have no impact on the resultset: >

Re: [GENERAL] Eliminating bad characters from a database for

The manual suggests: iconv -c -f UTF-8 -t UTF-8 -o cleanfile.sql dumpfile.sql. The -c option removes invalid character sequences. A diff of the two files will show the sequences that are invalid. iconv reads the entire input file into memory so it might be necessary to use split to break up the dum

Re: [GENERAL] Connecting performance

Sounds like pgpool. http://pgpool.projects.postgresql.org/ On Thu, 2006-12-21 at 12:01 +0800, 马庆 wrote: > Dear : > > These days, I come across a problem that I can’t solve i , so > I ask U for help. > > Problem Description: > >I use RedHat AS 4 + PostgreSQL

Re: [GENERAL] Best Perl DBI Driver for Postgres

Try DBD::Pg. I don't know what OS you are using but if it is Windows and your perl package installation is by ActiveState, then last I checked DBD::Pg was not included with it. A ppm is available however. Mike On Thu, 2006-12-21 at 21:34 -0700, [EMAIL PROTECTED] wrote: > Can anyone rec

Re: [GENERAL] COALESCE function

. mike On Sun, 2006-12-31 at 00:44 -0500, Kevin Hunter wrote: > Hello All, > > Attempting to select two different column types with COALESCE returns > this error: > > ERROR: COALESCE types smallint and character varying cannot be matched > > Attempting the same thing with

Re: [GENERAL] could not open file xxxx for writing: Permission

That usually means that the database user doesn't have Windows file level permissions to write to that folder. Maybe when you upgraded to pgadmin 1.6 and now are using a different user id to log into the it? Perhaps the destination directory was c: \postgresql\8.1\data before? Mike O

Re: [GENERAL] Tabbed data in tab-separated output

How are you attempting to restore the table after using psql? Psql insert statements? Pgdump? COPY FROM? Mike On Wed, 2007-01-03 at 17:59 -0800, [EMAIL PROTECTED] wrote: > I have a table which has a few VARCHAR columns whose first character > is a tab. If I run pg_dump on this table, it o

[GENERAL] Service startup - troubleshooting

Hello, I know this is probably a borderline Linux question but I think someone with PostgreSQL expertise will better be able to answer it (I already struck out on the Linux side and after much searching on the Web). I installed Postgres 8.1 on Ubuntu 6.10 using Synaptic. Postgres is listed under

Re: [GENERAL] Service startup - troubleshooting

Hi Richard, Thanks for your response. Below is a console session (again, this is on Ubuntu). I attempt to run the init script but can't start Postgres and don't see any error messages in the console or output in the log directory. I then switch to the 'postgres' user and can run pg_ctl to start

[GENERAL] SQL Question - Using Group By

ve me how many active and inactive each had! Please help me here understand how to approach this. Thank you, Mike ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] SQL Question - Using Group By

Thank you! Exactly what I needed. Mike On Feb 23, 4:42 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > You could use COUNT() in conjunction with NULLIF: > > select "Type", > count(nullif("Active", false)) as "Active Count", > cou

[GENERAL] SQL Question - Group By and % results per row

row basis so I can divide it? The only solution that comes to my mind is create a subquery that does a (select count(*) from... where... ) of the original grouped by sql statement. Thank you for your help in advance, Regards, Mike ---(end of broadcast

Re: [GENERAL] Trying to get postgres to use an index

> Well, you're joining the entire two tables, so yes, the seq scan might > be faster. My mistake. When composing the email to state the problem, I accidentally gave a wrong versionof the join query. Here is the corrected version, which still has the sequential scan... explain select notificat

[GENERAL] Rolling back an update

Is it possible to undo a transaction after it has completed (using 8 beta1) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] Caching/Indexing Function Output

unction? clearly I don't want to do this for *all* the functions I've written, but it would probably speed these functions up considerably? Thanks! Mike Pultz [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Caching/Indexing Function Output

> On Thu, Dec 23, 2004 at 01:22:42PM -0800, Mike wrote: > > > My question is- is there anyway, since a call to sp_host('10.0.0.1') will > > always > > return the same value (the primary key/sequence value from the ip_addresses > > table), to cache/index th

[GENERAL] Invalid input for numeric problem

I have the following view (output from psql \d) Column | Type | Modifiers +---+--- code | character varying(15) | subhead| text | sc_description | character varying(60) | Grant

[GENERAL] Problem with NOT IN and Sub-Select

I have the following query SELECT vw_mail_add.contact_id, vw_mail_add.first_name, vw_mail_add.last_name, vw_mail_add.address1, vw_mail_add.add2, vw_mail_add.add3, vw_mail_add.add4, vw_mail_add.add5, vw_mail_add.add6 FROM vw_mail_add JOIN tb_contact_role ON vw_mail_add.contact_id = tb_contact_role.

[GENERAL] When is a blank not a null or ''

I have the following query (I have removed all nulls from the field as test) SELECT first_name,work_email FROM tb_contacts WHERE tb_contacts.work_email <>''; However I get loads of blank email addresses coming up anyone any ideas ---(end of broadcast)---

Re: [GENERAL] When is a blank not a null or ''

On Wed, 2005-02-02 at 11:31 +0100, Troels Arvin wrote: > On Wed, 02 Feb 2005 09:59:30 +0000, mike wrote: > > > SELECT first_name,work_email FROM tb_contacts WHERE > > tb_contacts.work_email <>''; > > > > However I get loads of blank email address

Re: [GENERAL] When is a blank not a null or ''

On Wed, 2005-02-02 at 11:26 +0100, Alban Hertroys wrote: > mike wrote: > > I have the following query (I have removed all nulls from the field as > > test) > > > > SELECT first_name,work_email FROM tb_contacts WHERE > > tb_contacts.work_email <>'&#

[GENERAL] Confused by to_char

I am am trying to get a day string from a date using to_char ie: SELECT date1,ti1 ,to1,ti2,to2,adj,ei,eo,to_char('2005-02-07','Day') FROM vw_times_list1 however I get function to_char("unknown", "unknown") is not unique (using to_date does not recognise the date format) anyone any ideas what

Re: [GENERAL] Confused by to_char

On Tue, 2005-02-08 at 13:00 +, Ragnar Hafstaà wrote: > On Tue, 2005-02-08 at 12:28 +0000, mike wrote: > > I am am trying to get a day string from a date using to_char ie: > > > > SELECT date1,ti1 ,to1,ti2,to2,adj,ei,eo,to_char('2005-02-07','Day') FR

Re: [GENERAL] no self-joins in views?

On Thu, 2005-02-10 at 18:20 +0100, Christoph Pingel wrote: > >Could you give an actual example? > > Sure. The idea is that 'objects' (persons, books, places) from a > table obj are linked with each other in a link table ool where > objects from obj can appear in an 'subject' or a 'object' column

[GENERAL] DBI and placeholders question

Is it possible to have a placeholder on the left side of a select criteria? eg: SELECT CASE WHEN date_part('dow',?::date)=5 this bit is fine THEN CASE WHEN ? = 2 OR ? =3 OR ?=6 OR ?=7 OR ?=8 OR ?=12 THEN '7:00' here the ? is being read as NULL ie, output from LOG SELECT CASE WHEN date_part(

[GENERAL] How to search?

contain multiple words and be forgiving. How do I do it? Do I have to create a flat text of every record in my tables and then run the search through them for every word entered? That doesn't sound right? It would exhaust my database with a few users... Regards,

Re: [GENERAL] How to search?

Thanks, Mike ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Indexing Question

ield_1 with the intention of having postgreSQL place those records next to each other for faster queries that wouldn't necessarily reference field_1? Thanks, Mike ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] pg_autovacuum on Windows triggers string warning

etter info? Currently they are client_min_messages = warning log_min_messages = warning log_min_error_statement = warning Mike On Thu, 2006-02-23 at 17:27 -0500, Tom Lane wrote > "Mike G." <[EMAIL PROTECTED]> writes: > > I have the po

Re: [GENERAL] invalid UTF-8 byte sequence detected

If you don't care to store those characters then maybe you should change the database character set to use SQL_ASCII instead of UTF-8. I believe ASCII will quietly discard those characters when converting from UTF-8. Mike On Wed, 2006-03-15 at 23:20 -0600, Wes wrote: > Based on a c

Re: [GENERAL] question about pg_hba.conf

Never been a problem for me. On Mon, 2006-03-20 at 15:29 -0600, Tony Caduto wrote: > Does anyone know if the server would have problems reading pg_hba.conf > if the number of spaces where changed between fields or tabs where added? > > > thanks, > > Tony > > ---(end of

Re: [GENERAL] How to Backup like in mysql or ms sql server

On windows the database files are under C:\program files\postgresql\8.1 \data There are a number of different ways a backup can be done and a file level copy/paste is one of them. See http://www.postgresql.org/docs/8.1/interactive/backup.html Mike On Sun, 2006-07-02 at 11:01 +0700, Joko

Re: [GENERAL] Crystal Reports 8.5 - SQL Expressions

Last I tried, a few years ago, Crystal 8.5 would not work at all with PostgreSQL. Version 9 works but the later service packs handle it much better. Can you browse the table data through the database expert? Mike On Wed, 2006-07-12 at 10:23 -0300, Juan Ignacio Lalla wrote: > Hello, >

Re: [GENERAL] Installing and using SLONY-I cluster

There is no official free replication solution for Windows yet. The next version of Slony is to have it. If you wish to test it see http://people.planetpostgresql.org/xzilla/index.php?/archives/200-Alpha-testing-Slony-on-win32-Crib-Notes.html for how it can be installed on windows. Mike On Mon

[GENERAL] test

None of my mail messages seem to be getting through to the list, so this is a test ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] correlated delete with 'in' and 'left outer join'

t;in"? >> >> >> Perhaps >> delete from LogEvent where EventType != 'i' and not exists >> (select * from Item i where i.ItemID=LogEvent.ItemID); > > Maybe I'm not reading his subquery correctly, but the left outer > join will produce a

Re: [GENERAL] Problem restoring Database

On Thu, 2004-04-01 at 20:08, Joshua D. Drake wrote: > mike wrote: > > I have just upgraded froom Fedora test1 to test2 which has upgraded > > postgres version from 7.4.2 to 7.4.5 (frrom rpm -q) > > Uhh unless I am missing something what you have done is impossible

[GENERAL] Question about inserts

Is it possible to to the following I have tables which are updated via webpage (perl) with fields of type int and date (all nullable). If the values are blank the entire insert fails, with a wrong type error. Is there any way to stop this behaviour so that the valid information is allowed,but th

[GENERAL] Insert increment based on a group by?

I am trying to do the following I have a table with three relevant fields subj, area, and no What I want to do is insert a sequential number by a group on the first two fields eg: values existing sub | area| no 1 | 1 | 1 1 | 1 |

[GENERAL] Help needed on time data types

Hi I am trying to setup a timesheet app. However I have come up against an unexpected problem (possibly fatal) I cannot seem to find a field type in postgres that is equivalent to h:mm without enforcing a 24 hour day limit. This seems to preclude pg from use - am I correct? All the date-time type

Re: [GENERAL] Invalid input for integer on VIEW

On Tue, 2004-08-24 at 15:42 +0100, mike wrote: > I have the following view definition > > Column | Type | Modifiers > +---+--- > bcode | character varying(15) | > sub

[GENERAL] SQL query - single text value from group by

Hi I am trying to work out if this is possible in a select query I have a group by query which could result in several rows, what I want to do is do a text equivalent of a sum() eg: SELECT sum(inv_id),date,cust from invoice group by date,cust Is there any way to get to a single concatenated in

Re: [GENERAL] SQL query - single text value from group by

On Wed, 2004-09-08 at 17:13 +0100, Richard Huxton wrote: > mike wrote: > > Hi > > > > I am trying to work out if this is possible in a select query > > > > I have a group by query which could result in several rows, what I want > > to do is do a text equiva

[GENERAL] reordering sequences

is it at all possiable to reorder a squence? I'm finding that our sequences get some what out step and messed and would like to ocassionaly reorder them, though I'm unable to find anything that might be able to do this.   Mike

[GENERAL] GUI Application mode

Hi Folks, Is there any GUI application mode for Unix that can run PostgreSQL? Thank you in advance. -- Best Regards, Mike Web Programmer TKO Systems, Ltd. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

[GENERAL] compiling ...

7; pgsample.o(.text+0x1bb): undefined reference to `PQfinish' collect2: ld returned 1 exit status make: *** [pgsample] Error 1 Anyone know the solution for this? Thanks. -- Best Regards, Mike TKO Systems, Ltd. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Error in compiling PHP with PostgreSQL support

. Tell me also what kind of Operating System that you use. Mike ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] PSQL Books

I'm looking for at least two good books on psql, are there any out ther, if so can someone suggest some to me? Mike

[GENERAL] postgres startup

what would be the best way to start up postgres? I used to use a modified version of the init script provided in the rpms, but since I've begun to use the 7.1 betas it doesn't always seem to want to start up. Is there an easier way or does 7.1 require a difernt type of init script?   Mike

[GENERAL] Re: Bad book review

ences. =) Mike - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "PostgreSQL-general" <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 11:06 PM Subject: Bad book review > I am not sure how many people have looked at my book on Am

[ADMIN] Re: what means "INSERT xxx yyy" ?

maximum ? and what is the current > transaction ID ? > Is it the first number ? > > Thank you INSERT 19331808 1 That just tells you waht you did "INSERT" and it displays the oid for that insert "19331808", as for the 1, uncertain waht it is, but its always there Mike

[GENERAL] Re: Location of 7.1 version for download

ftp://ftp.postgresql.org/pub/dev/ all of the 7.1 files are there though they are still in beta form.   Mike - Original Message - From: Paulo Parola To: [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 10:04 AM Subject: Location of 7.1 version for download

[GENERAL] reindexing sequences

is there a way to reindex a sequence? if so how and is it in the curent docs?   Mike

[GENERAL] Re: Select

SELECT * FROM employee WHERE empname LIKE 'P%' the above would work only if you want to search for people w/ names starting w/ P Mike - Original Message - From: "Marcelo Pereira" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 17, 200

[GENERAL] pg_dump error

I'm trying to back up a table by dumping to a text file, but in the proccess of dumping I get the following error   dumpSequence(pilgram_en_id_seq): different sequence name returned by SELECT: pilgram_cross_id_seq   I'm not sure what this means, and I have no idea how to corect it.   Mike

[GENERAL] Re: PHP and pgsql 7.1

I had the same problems my self w/ php and pam_pgsql looks like 7.1 doesn't put things into the folders that you are expecting. ie 7.0.3 places libs in /usr/lib/pgsql, in 7.1 they go in /usr/lib/postgres Mike > Greetings, > > Trying to install PHP on a machine with the pgsql cli

[GENERAL] Re: Problem installing Postgresql

You should be using gmake instead of make. ./configure gmake gmake install Mike > I am running OpenLinux 2.3 (Caldera) out of the box. Trying to install > PostGreSQL I seem to be unable to get past the 'make' process. Errors I > get at the end of the proc

[GENERAL] inputs into query planner costing

Hi there, I'm having an issue with query performance between 2 different pgsql environments. Ther first is our current production postgres server with is running 9.3.5 on Centos 5 x64. The second system is Amazon's RDS postgres as a service. On our local DB server we have a query that executes

Re: [GENERAL] inputs into query planner costing

Thanks for the responses For anyone searching in the future I'll answer Tom's questions and list the boneheaded fix that it ended up actually being (really painful as I've been fighting this for a week). 1) According to amazon they run stock postgres as far as the query planner is concerned. 2) Y

[GENERAL] Invalid memory alloc request size

1 with 102 table(s) from provider 1 2015-08-24 06:50:33 UTC ERROR remoteWorkerThread_1_1: error at end of COPY IN: ERROR: invalid memory alloc request size 1970234207 CONTEXT: COPY sl_log_1, line 97033: [image: Clutch Holdings, LLC] <http://www.clutch.com> Mike James | Manager of Infra

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston Sent: Wednesday, June 15, 2016 1:31 PM To: Durgamahesh Manne Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] regarding schema only migration from sqlserver to postgres w

Re: [GENERAL] PostgresSQL and HIPAA compliance

on securing PHI on relational databases, you'll find lots of details around data access roles, documentation, processes, data obfuscation, etc. Mike -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

Re: [GENERAL] OT hardware recommend

e has said, just buy a 1 TB Samsung EVO 850 for $300 (USD) and call it a day. :) Mike

Re: [GENERAL] Stored procedure version control

window, allowing me directly edit/clone without leaving the editor. My coding efficiency using this model is quite high...the overhead of using git is trivial. For rollbacks, we can simply point to the prior stored proc version and recompile those. For DDL rollbacks, I have to code those scripts

Re: [GENERAL] Re: Clustered index to preserve data locality in a multitenant application?

onster loaner Cisco UCS server. Should have that posted to the Perform list later this week. Mike Sofen (USA)

Re: [GENERAL] UUIDs & Clustered Indexes

s are also design insurance for me in case I need to shard, since I'll need/want that uniqueness across servers. Mike Sofen

Re: [GENERAL] UUIDs & Clustered Indexes

From: George Neuner Sent: Tuesday, August 30, 2016 5:54 PM >Mike Sofen wrote: So in this scenario, I'm using >BOTH bigserials as the PK and uuids as AKs in the core tables. I >reference the bigints for all joins and (have to) use the uuids for the >filters. It's

Re: [GENERAL] UPDATE OR REPLACE?

ign pattern. In my mind primary keys are supposed to be static, stable, non-volatile...aka predictable. It feels like an alien invading my schema, to contemplate such an activity. I hope PG never supports that. Postgres allows developers incredible freedom to do really crazy things. That d

Re: [GENERAL] Rackspace to RDS using DMS (Postgres 9.2)

server that we are demoing that costs ~$100k, as long as our batch sizes don’t exceed available memory – that’s where the larger Cisco pulls ahead. The $620/mo is the on-demand price, btw…the reserved price is much lower. $100k/ $620 = 161 months of operation before cost parity. Mike S

Re: [GENERAL] IDE for function/stored proc development.

From: Tim Uckun Sent: Saturday, September 03, 2016 2:37 AM Does anybody use an IDE for doing heavy duty stored proc development? PGadmin is decent but I am looking for something better. I have been using the Datagrip app (from Jetbrains), from its beta release up through now v 2016.2 and lov

[GENERAL] how to monitor the progress of really large bulk operations?

t eliminate my need: how to view the state of a transaction in flight, seeing how many rows have been read or inserted (possible for a transaction in flight?), memory allocations across the various PG processes, etc. Possible or a hallucination? Mike Sofen (Synthetic Genomics)

Re: [GENERAL] how to monitor the progress of really large bulk operations?

From: Pavel StehuleSent: Tuesday, September 27, 2016 9:18 PM 2016-09-28 6:13 GMT+02:00 Pavel Stehule mailto:pavel.steh...@gmail.com> >: Hi 2016-09-27 23:03 GMT+02:00 Mike Sofen mailto:mso...@runbox.com> >: Hi gang, how to view the state of a transaction in flight, seeing how ma

Re: [GENERAL] Graphical entity relation model

), and the fully comprehensive, with a very modern looking UI. In contrast, there are the over-priced dinosaurs with old ugly UIs. A while back I reviewed some of the modeling tools, and none did it for me, I went ahead and got another license to xcase. Mike Sofen (Synthetic Genomics)

Re: [GENERAL] Immutable datastore library?

small - up to 100k rows or less, and processed in under 100ms. But even when there was a network outage and we had to do a catch up load with millions of rows, it ran very quickly. IOWs, the double write overhead was very modest, especially with modern disk performance. Mike Sofen (Synthetic G

Re: [GENERAL] initdb createuser commands

isn’t skilled in sql, the requests you’ve made won’t assist them at all. Mike Sofen (Synthetic Genomics)

Re: [GENERAL] Storing files: 2.3TBytes, 17M file count

, this is all real time web app stuff. This is a model that could work for anyone dealing with large objects (text or binary). The nice part is, the original 25TB of data storage drops to 5TB – a much more manageable number, allowing for significant growth, which is on the horizon. Mike

Re: [GENERAL] Syntax error needs fresh eyeballs

g all table names and references to them, or double-quoting all identifiers. Mike

Re: [GENERAL] Performance PLV8 vs PLPGSQL

tailored the model to match. Mike Sofen (Synthetic Genomics)

Re: [GENERAL] LYDB: What advice about stored procedures and other server side code?

ans are created, etc. ORMs are a shortcut to getting an app talking to data, but aren't a substitute for a proper, scalable data tier. IMO...being a data specialist... :-) Mike Sofen (Synthetic Genomics) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

Re: [GENERAL] Column Tetris Automatisation

le, order does matter...it all ties together nicely, making it easier for other developers to follow an identical pattern across all of the database objects. All of that said, the notion of embedding Tetris functionality into a codebase makes me smile, for some reason... Mike Sofen -- Sent

Re: [GENERAL] How to delete few elements from array beginning?

mal sql set-based operations that are readable, understandable, maintainable and very fast/scalable. When I see row by row operations (looping or cursors) in what should be a real time query…that’s my alarm bell that perhaps the code has wandered off a valid solution path. Mike

[GENERAL] vacuum - reclaiming disk space.

I have a large table with numerous indexes which has approximately doubled in size after adding a column - every row was rewritten and 50% of the tuples are dead. I'd like to reclaim this space, but VACUUM FULL cannot seem to finish within the scheduled downtime. Any suggestions for reclaiming th

Re: [GENERAL] I/O - Increase RAM

d get the behaviors sorted out, then it should become obvious what needs fixing. Mike -- 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] Re: Why is the comparison between timestamp and date so much slower then between two dates

27;t seem prevalent in PG...instead I see people using functions within functions within functions, the cascading impact of which becomes very hard to unravel. Mike Sofen -- 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] Function PostgreSQL 9.2

save, oh, perhaps 10 years of wasted effort and 12 million emails. This is as close to bandaids on bandaids on steroids that it comes. Really – rethink your solution model. Mike From: drum.lu...@gmail.com <mailto:drum.lu...@gmail.com>Sent: Tuesday, April 19, 2016 7:40 PM Just for

Re: [GENERAL] truncate table getting blocked

From: Jayadevan M Sent: Tuesday, April 26, 2016 6:32 AM Hello, I have a python script. It opens a cursor… Thanks, Jayadevan

Re: [GENERAL] (VERY) Slow Query - PostgreSQL 9.2

re this table directly (requiring a change in app code that was filling it), or use it to fill a proper table that already has everything decomposed from the long full_path string via post-processing after the insert. A third consideration would be to archive off older/unneeded rows to a history table to reduce row counts. This is about proper structure. Mike Sofen

Re: [GENERAL] Function PostgreSQL 9.2

eir peers soon lose interest in collaborating with them, if you catch my drift… Mike Sofen

  1   2   3   4   5   6   7   8   9   10   >