Re: [GENERAL] Large data and slow queries

Citus is also now just an extension. Sounds pretty awesome, I'll certainly consider your system if/when we decide to make changes. On 22 April 2017 at 08:41, Andrew Staller <and...@timescale.com> wrote: > Samuel, > > Short answer to your questions: (1) TimescaleDB and Citus

Re: [GENERAL] Large data and slow queries

Scott, Vick, the vast majority of the data is generic. But there are some specific events we need to look up quickly which are probably less than a few 100,000 records. We did evaluate partial indexes vs full indexes. The partial index speeds up our specific queries significantly while only taking

Re: [GENERAL] Large data and slow queries

Andrew, how would timescaledb compare to citus - and is timescaledb an extension to postgres or is it an entirely separate system? On 21 April 2017 at 02:44, Andrew Staller <and...@timescale.com> wrote: > Awesome thread. > > Samuel, > > Just wanted you to be aware of

[GENERAL] cluster on brin indexes?

I see this, but no follow up: https://www.postgresql.org/message-id/CAEepm%3D2LUCLZ2J4cwPv5DisHqD9BE_AXnqHGqf0Tj-cvtiqVcQ%40mail.gmail.com So, is it possible or not? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Large data and slow queries

Okay, so after changing longitude/latitude to float4, and re-organizing the table a bit, I got the query down from about 8 minutes to 40 seconds. The details are in the gist comments: https://gist.github.com/ioquatix/bddda36d9e4ffaceb7a62d7b62259121 Now, just need to get performance another 2

Re: [GENERAL] Large data and slow queries

Ah right, yeah, it's insert only. So, it's never been vacuumed. On 20 April 2017 at 01:25, Stephen Frost <sfr...@snowman.net> wrote: > Greetings, > > * Samuel Williams (space.ship.travel...@gmail.com) wrote: >> Thanks for all the suggestions Stephen. >> >> > Th

Re: [GENERAL] Large data and slow queries

ing the default 9.6 config, I thought that auto-vacuum was on by default? On 20 April 2017 at 00:48, Stephen Frost <sfr...@snowman.net> wrote: > Greetings, > > * Samuel Williams (space.ship.travel...@gmail.com) wrote: >> We want the following kinds of query to be fast: &g

Re: [GENERAL] Large data and slow queries

Martijn that is a good question. It's because we are only concerned with a subset of events for this index and this particular query. The query planner can recognise this and use the index correctly. By doing this, we reduce the size of the index significantly. In the best case, where we only

Re: [GENERAL] Large data and slow queries

explicitly? The correlation between user_id and location... well, it's somewhat temporally related. On 19 April 2017 at 22:50, Alban Hertroys <haram...@gmail.com> wrote: > >> On 19 Apr 2017, at 6:01, Samuel Williams <space.ship.travel...@gmail.com> >> wrote: >>

Re: [GENERAL] Large data and slow queries

> Did that 50% performance gain come from just the datatype, or that fact that > the index became smaller? How would one measure this? On 19 April 2017 at 19:48, John R Pierce wrote: > On 4/19/2017 12:31 AM, vinny wrote: >> >> Given the number of records, my first thought

Re: [GENERAL] Large data and slow queries

<pie...@hogranch.com> wrote: > On 4/18/2017 9:01 PM, Samuel Williams wrote: >> >> We want the following kinds of query to be fast: >> >> SELECT ... AND (latitude > -37.03079375089291 AND latitude < >> -36.67086424910709 AND longitude > 174.6307139779924

Re: [GENERAL] Large data and slow queries

Oh, I've also tried earth distance and ll_to_earth in a GIST index... it was slower that the BTREE index on a small subset of data in my tests. On 19 April 2017 at 16:01, Samuel Williams <space.ship.travel...@gmail.com> wrote: > Hi. > > We have 400,000,000 records i

[GENERAL] Large data and slow queries

our index to be more discrete, e.g. created_at::date, would this help? The set union of user_ids for 365 days should be pretty fast? I'm open to any ideas or suggestions, ideally we can keep optimisations within the database, rather than adding a layer of caching on top. Kind regards, Samuel -

Re: [GENERAL] Index size

wrote: > Samuel Williams <space.ship.travel...@gmail.com> wrote: >> So, uh, my main question was, does MySQL add null values to an index, and is >> this different from Postgres... > > Samuel, > > A quick google says that Mysql does index NULLs. Ask a Mysql group to ge

Re: [GENERAL] Index size

Melvin, uh... I'm a software engineer... since when was it a problem to want to know how things work and why they are different? If you have nothing to contribute of a relevant technical nature, please don't reply, I'm really not interested.

Re: [GENERAL] Index size

blighty.com> wrote: > >> >> > On Dec 3, 2016, at 3:57 PM, Samuel Williams < >> space.ship.travel...@gmail.com> wrote: >> > >> > Thanks everyone for your feedback so far. I've done a bit more digging: >> > >> > MySQL in MBytes (about 350 mil

Re: [GENERAL] Index size

So, uh, my main question was, does MySQL add null values to an index, and is this different from Postgres. The schema is irrelevant, except that the column allows null values. I noticed when you create an index you can add a where clause. Could it be I should add WHERE the fields are not null?

Re: [GENERAL] Index size

be ignored from the index. Thanks, Samuel -- 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] Index size

Is there any reason why for the same data set, and same indexes, that the data in postgres would be significantly larger than innodb/mariadb? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] Index size

I'd like to understand a bit more about indexes in PG. When I have a row in a table, and an index, say, for a single column, does that duplicate the entire row on disk? Or is there some kind of id lookup involved? Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] initdb createuser commands

> Really? So naming them pg_initdb and pg_createdb would help to clarify their > use? Yes. > Perhaps you missed: https://www.postgresql.org/docs/9.6/static/app-pg-ctl.html I meant a man page that details the ENTIRE Postgres command line tools. > Command line aliases and other stuff I've been

Re: [GENERAL] initdb createuser commands

2016 at 06:50, Daniel Verite <dan...@manitou-mail.org> wrote: > Samuel Williams wrote: > >> John - that's an interesting example. If it's that easy, why isn't >> that the approach given in tutorials and other documentation? What was >> the motivation for the

Re: [GENERAL] initdb createuser commands

Sorry, just to clarify, b "worst" I don't mean functionality, I mean the way the commands are named and organised. On 31 October 2016 at 13:07, Samuel Williams <space.ship.travel...@gmail.com> wrote: > Mike, I agree with "the postgres way of doing things". I'm suggest

Re: [GENERAL] initdb createuser commands

16 at 12:51, Mike Sofen <mso...@runbox.com> wrote: > From: Samuel Williams Sent: Sunday, October 30, 2016 3:42 PM > As a community I'd think that having feedback from a new user would be > valuable since as you say, sometimes when you get ingrained into the "way of > doing th

Re: [GENERAL] initdb createuser commands

ffort required to improve things. But so far, I'm getting the opposite. Kind regards, Samuel On 31 October 2016 at 04:30, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 10/30/2016 12:15 AM, Samuel Williams wrote: >> >> Adrian, I like the idea of teaching the appropr

Re: [GENERAL] initdb createuser commands

John - that's an interesting example. If it's that easy, why isn't that the approach given in tutorials and other documentation? What was the motivation for the createuser command? On 30 October 2016 at 20:20, John R Pierce <pie...@hogranch.com> wrote: > On 10/30/2016 12:15 AM, Samuel

Re: [GENERAL] initdb createuser commands

PR but can you confirm intention to work on it to acceptance? Otherwise I'm just wasting everyone's time including my own :) On 30 October 2016 at 13:31, Gavin Flower <gavinflo...@archidevsys.co.nz> wrote: > On 30/10/16 11:25, John R Pierce wrote: >> >> On 10/29/2016 3:02 PM,

Re: [GENERAL] initdb createuser commands

FYI, https://wiki.archlinux.org/index.php/PostgreSQL mentions initdb, createuser, createdb and several others. I think my suggestion is still relevant and something that would improve the system for new users :) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] initdb createuser commands

October 2016 at 13:46, John R Pierce <pie...@hogranch.com> wrote: > On 10/28/2016 4:55 PM, Samuel Williams wrote: >> >> Even if maintaining the old commands, they could print >> out to stderr "This command is deprecated and now wraps `pg_ctl init`. >>

Re: [GENERAL] initdb createuser commands

e postgres is in other areas, it's disappointing that the command line tools don't reflect the same level of engineering and thoughtfulness. On 29 October 2016 at 16:36, Samuel Williams <space.ship.travel...@gmail.com> wrote: > I think there is an opportunity here to make the experience for

Re: [GENERAL] initdb createuser commands

date the Arch Linux documentation to prefer these commands? What is the recommendation here? On 29 October 2016 at 12:39, John R Pierce <pie...@hogranch.com> wrote: > On 10/28/2016 4:31 PM, Samuel Williams wrote: >> >> Just wondering as the naming of these commands seems overly generic

[GENERAL] initdb createuser commands

available since there is no common prefix (e.g. pg_) for these commands. Thanks Samuel -- 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] SELECT .. WHERE id IN(..)

On 05/16/2015 10:44 PM, Maks Materkov wrote: I have a database, table users, with column profile_id, and the following query: EXPLAIN ANALYZE SELECT * FROM users_user WHERE profile_id IN (...50 ids...); Result: Index Scan using users_user_83a0eb3f on users_user (cost=0.50..292.22 rows=50

Re: [GENERAL] Archeiving and Purging

On 03/18/2015 09:20 AM, adityagis wrote: Dear Users, I have lots of data in my DB. I need to do archeiving and purging of my data. Can anyone please help me with step by step riles? Thanks in Advance. Aditya Kumar -- View this message in context:

Re: [GENERAL] Partitioning and constraint exclusion

On 03/04/2015 12:11 AM, David G Johnston wrote: In short - since the planner determines exclusion constraints and the executor, which strictly follows the planner in the query execution process, would be the one to determine what the value of your date is - there is no way for a single query to

[GENERAL] Partitioning and constraint exclusion

Howdy, I spent a majority of today playing around with pg_partman (awesome tool btw!). I am mainly using the time-static method with an interval of one month. I wanted to see what performance improvements I could get with some common queries that are used by our analytics team. A lot of these

Re: [GENERAL] Postgres architecture for multiple instances

On 02/22/2015 01:53 PM, Scott Marlowe wrote: I'd run a debian based distro (Ubuntu or Debian work well) and use the pg_* commands to create the clusters the same way. Gives you the maximum separation for clients. pg_createcluster Usage: /usr/bin/pg_createcluster [options] version cluster

Re: [GENERAL] Postgres architecture for multiple instances

On 02/21/2015 05:25 PM, David Steele wrote: On 2/21/15 6:08 PM, Adrian Klaver wrote: Currently the built in replication solutions work at the cluster level, not at the database level. There are third party tools, Slony and Bucardo come to mind, that can work at a more focused level. Again,

[GENERAL] Postgres architecture for multiple instances

Howdy, I am looking for advice on migrating to postgres from another database system. Without going into too much detail, my company offers a software solution which we self host ourselves in our data center. We have gotten a green light from management to start using postgres as a free and

[GENERAL] PgAdmin errors

When I try to run SQL from PgAdmin : CREATE TABLE tse_history_old LIKE tse_history INCLUDING ALL WITH OIDS I get this error ERROR: syntax error at or near LIKE LINE 2: CREATE TABLE tse_history_old LIKE tse_history INCLUDING ALL ... testing, I find that using the word LIKE always causes errors

Re: [GENERAL] PgAdmin errors

: [GENERAL] PgAdmin errors On 3/26/2014 12:32 PM, Hall, Samuel L (Sam) wrote: When I try to run SQL from PgAdmin : CREATE TABLE tse_history_old LIKE tse_history INCLUDING ALL WITH OIDS I get this error ERROR: syntax error at or near LIKE LINE 2: CREATE TABLE tse_history_old LIKE tse_history INCLUDING

Re: [GENERAL] PgAdmin errors

: Wednesday, March 26, 2014 3:02 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] PgAdmin errors On 3/26/2014 12:58 PM, Hall, Samuel L (Sam) wrote: That doesn't help. Even this CREATE TABLE tse_history_old (LIKE tse_history) gives an error the exact same error ? -- john r pierce

Re: [GENERAL] PgAdmin errors

Yes PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Wednesday, March 26, 2014 4:03 PM To: Hall, Samuel L (Sam) Cc: John R Pierce; pgsql-general@postgresql.org

Re: [GENERAL] Issues with patitionning and triggers

); -- NOTICE: NEW row is now : (1, 42, 2014-02-19 16:37:27.134194) -- INSERT 0 1 So, we clearly see that trigger_insert_00 is called in both cases. I don't understand why the query fails on the parent, but works when the INSERT targets the child table directly. Regards, Samuel Gilbert On 2014-02-18

[GENERAL] Issues with patitionning and triggers

) VALUES (9, 2, 128, '2014-01-01 00:00:00', '24 hours', 42); Why isn't the BEFORE INSERT trigger on the child table being executed? Cheers, Samuel Gilbert -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Issues with patitionning and triggers

On 2014-02-18 14:25:59 Adrian Klaver wrote: On 02/18/2014 02:10 PM, Samuel Gilbert wrote: I have data warehousing DB 2 fairly big tables : one contains about 200 million rows and the other one contains about 4 billion rows. Some queries are now taking way too long to run ( 13 hours). I

Re: [GENERAL] Issues with patitionning and triggers

. As Tom Lane pointed out, it's hard to get help without a complete self- contained example. I will work on writing that up tomorrow. Cheers! On 2014-02-18 15:02:41 Adrian Klaver wrote: On 02/18/2014 02:42 PM, Samuel Gilbert wrote: On 2014-02-18 14:25:59 Adrian Klaver wrote: On 02/18/2014 02

Re: [GENERAL] Issues with patitionning and triggers

On 2014-02-18 17:59:35 Tom Lane wrote: Samuel Gilbert samuel.gilb...@ec.gc.ca writes: All of this was done on PostgreSQL 9.2.0 64-bit compiled from the official source. Significant changes in postgresql.conf : Why in the world are you using 9.2.0? You're missing a year and a half worth

[GENERAL] backup and restore functions

I have a Postgressql-9.2 database with postgis-2.0 in production service. Due, I think, to a bad postgis upgrade, there are both old and new functions present. I am planning to install Postgresql-9.3 and Postgis-2.01 and then copy the data over with pg_upgrade. My question is: Will this also

[GENERAL] Update quey

I have a table (pubacc_lo) from the US government with 500,00+ rows. It has latitude and longitude in three columns each for degrees, minutes and seconds. I need a Point geometry column. So I wrote this query: with mydata AS (SELECT (pubacc_lo.lat_degrees + pubacc_lo.lat_minutes/60 +

Re: [GENERAL] Update quey

Thank you! That worked fine. From: bricklen [mailto:brick...@gmail.com] Sent: Friday, August 23, 2013 10:08 AM To: Hall, Samuel L (Sam) Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Update quey On Fri, Aug 23, 2013 at 8:04 AM, Hall, Samuel L (Sam) sam.h...@alcatel

[GENERAL] Problem with at_askml function in Postgis

Using PostgreSQL 9.1.8 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit POSTGIS=2.0.1 r9979 GEOS=3.3.3-CAPI-1.7.4 PROJ=Rel. 4.8.0, 6 March 2012 GDAL=GDAL 1.9.2, released 2012/10/08 LIBXML=2.8.0 LIBJSON=UNKNOWN TOPOLOGY RASTER Postgis seems to be

[GENERAL] Extra space when converting number with to_char

Is there a reason why to_char adds a leading space? Is this a bug? I can easily fix this with trim(leading ' ' from to_char(num, '0')), but, being of a curious nature, I'd like ton know why I need to do that. -- Samuel Gilbert -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Extra space when converting number with to_char

Thank you, it works. The documentation gave me the impression that the FM modifier only applied to date/time since it was under Usage notes for date/time formatting: Samuel On Friday, October 26, 2012 16:01:08 Moshe Jacobson wrote: You want to use a format of 'FM0' (fill mode

Re: [GENERAL] [PERFORM] Inaccurate Explain Cost

On Wed, Sep 26, 2012 at 1:21 PM, hubert depesz lubaczewski dep...@depesz.com wrote: On Wed, Sep 26, 2012 at 02:38:09PM -0400, Robert Sosinski wrote: The first query shows a cost of 190,169.55 and runs in 199,806.951 ms. When I disable nested loop, I get a cost of 2,535,992.34 which runs in

[GENERAL] Double types

I have an application that writes an Excel Spreadsheet to postgres. For the values that go in number fields, I check the Excel values for dbnull and set the parameters to 0, like this: cmd.Parameters(9).Value = 0. Npgsql throws an error format specifier was invalid If I do this:

[GENERAL] Can someone help explain what's going on from the attached logs?

] FATAL: the database system is starting up 2011-10-18 10:34:09 MDT [17669]: [1-1] FATAL: the database system is starting up Samuel

[GENERAL] interesting finding on order by behaviour

I ran the same tests in SQL Server 2008R2, Oracle10 and PostgreSQL 9.0.4 and found something interesting... set up = drop table t1 create table t1 (f1 varchar(100)) insert into t1 (f1) values ('AbC') insert into t1 (f1) values ('CdE') insert into t1 (f1) values ('abc') insert into t1 (f1)

Re: [GENERAL] Another unexpected behaviour

Thanks. But I am not looking for how to avoid the problem at this moment, I am more interested in why PostgreSQL is designed to work this way. To make the problem more obvious, drop table if exists t1; create table t1 (f1 int); create unique index uix_t1 on t1(f1) ; insert into t1(f1) values (1),

Re: [GENERAL] Another unexpected behaviour

Thanks for the reply. You are right, the result is all or nothing, so it's still atomic. I found my mistake and posted a clarification for my question. I know in PostgreSQL 9.0 unique constraint can be set to deferrable. However still no luck for unique indexes. The real question is that why

Re: [GENERAL] UTC4115FATAL: the database system is in recovery mode

Craig Ringer craig(at)postnewspapers(dot)com(dot)au writes: On 05/30/2011 10:29 PM, Mathew Samuel wrote: 2011-03-28 10:44:28 UTC3609HINT: Consider increasing the configuration parameter checkpoint_segments. 2011-03-28 10:44:38 UTC3609LOG: checkpoints are occurring too frequently (10

[GENERAL] UTC4115FATAL: the database system is in recovery mode

Hi, I see the following error as found in pg.log: UTC4115FATAL: the database system is in recovery mode Actually that message was logged repeatedly for about 4 hours according to the logs (I don't have access to the system itself, just the logs). Leading up to that error were the following in

[GENERAL] Re: [SQL] Re: 500KB PDF files for postgresql8.3, which is the most efficient way?

On Fri, May 27, 2011 at 9:15 AM, Emi Lu em...@encs.concordia.ca wrote: Solution: (1) Save pdfs to file system, only point file name in psql8.3 (2) Save oids of pdfs into table (3) Save pdf files as bytea column in psql8.3 Pros and cons for (1), (2), (3), which

[GENERAL] COPY statement REAL vs VARCHAR precision issue

? -- Is it because of the behaviour of the COPY statement? Thank you for your help! Samuel -- 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] Blocked inserts on tables with FK to tables for which UPDATE has been revoked

mixed up and sent the wrong version of the test script to the list. However, even if it is not the right user, the problem remains. Samuel On Saturday, July 24, 2010 06:08:23 Alban Hertroys wrote: On 23 Jul 2010, at 20:39, Samuel Gilbert wrote: Hello, I have encountered a problem

[GENERAL] Blocked inserts on tables with FK to tables for which UPDATE has been revoked

, not how I would have expected the permissions to behave. Any help to resolve this issue will be greatly appreciated! Best Regards, Samuel -- 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] Help me stop postgres from crashing.

On Apr 24, 4:13 pm, t...@sss.pgh.pa.us (Tom Lane) wrote: Sam s...@palo-verde.us writes: A particular web application I am working has a staging version running one a vps, and a production version running on another vps. They both get about the same usage, but the production version keeps

Re: [GENERAL] Help me stop postgres from crashing.

On Apr 24, 3:53 pm, thombr...@gmail.com (Thom Brown) wrote: On 24 April 2010 18:48, Sam s...@palo-verde.us wrote: Hi, I am a web developer, I've been using postgesql for a few years but administratively I am a novice. A particular web application I am working has a staging version

Re: [GENERAL] Help me stop postgres from crashing.

On Apr 24, 3:53 pm, thombr...@gmail.com (Thom Brown) wrote: On 24 April 2010 18:48, Sam s...@palo-verde.us wrote: Hi, I am a web developer, I've been using postgesql for a few years but administratively I am a novice. A particular web application I am working has a staging version

[GENERAL] After a crash all my tables got wiped, but still using disk space.

to try access my data, im restoring my last backup, but i want try everything to get the most recent before give up. Thanks in advance. PS: Please, cc me a reply cos im not in the pgsql list. Samuel Abreu de Paula sam...@debian-ce.org Mike Ditka - If God had wanted man to play soccer, he

[GENERAL] Triggers et clefs primaires

où il y a un champ qui fait référence à la table sur laquelle il y a le trigger. Exemple d'application: INSERT INTO table1 (champ2, champ3) VALUES ('salut', 'samuel'); (la table1 as un champ1 (alias id) qui est un serial en clef primaire) - La fonction pgplsql (appelée par le trigger) récupère

Re: [GENERAL] Triggers et clefs primaires

Le mardi 26 août 2008 à 11:01 +0200, Guillaume Lelarge a écrit : Samuel ROZE a écrit : [...] J'ai un trigger (AFTER FOR EACH ROW) sur une table qui à chaque fois qu'il y a un enregistrement sur cette même table, exécute une fonction pgplsql qui éxécute elle-même une fonction PL/sh qui

[GENERAL] Migration of /data from 32bit to 8.2 64bit

Hi All, I want to migration an existing database from a 32bit server to a 64bit server. I will use exactly the same postgresql version (8.2.6). Did I need to dump the data to do this or a single copy of /data will work ? Is any interger lenght impact on /data ? Thanks,

[GENERAL] views to behave differently according to user and schema

vtest would be using VIEW nsp2.test, when user nsp3 loggs in it would use VIEW nsp3.test, for user nsp1 TABLE nsp1.test ... Cheers, -- Samuel Thoraval LIBROPHYT, Bioinformatique Centre de Cadarache ---(end of broadcast)--- TIP 4: Have you

[GENERAL] System catalog diagram

the information I need reading through the pg documentation. For instance I currently need to get the OID for a given namespace in order to query the pg_type table, and I don't know where to find that information... Regards, -- Samuel Thoraval ---(end of broadcast

Re: [GENERAL] System catalog diagram

Reading through "Chapter 41. System Catalogs" down to sub chapter "pg_type" I could actually easily get the namespace's OID from table pg_namespce: pg_namespace.oid. So sorry, may be reading through the documentation is good enough and not so difficult :-[ ... Samuel

Re: [GENERAL] Hot to restrict access to subset of data

I have been trying to use views to restrict access to a subset of data as stated : Using Andrus's example for user B with document in public schema : REVOKE ALL FROM public.document; CREATE SCHEMA b AUTHORIZATION b; CREATE VIEW b.document AS SELECT * FROM public.document WHERE DocumentType

Re: [GENERAL] Hot to restrict access to subset of data

Tom Lane a crit: Samuel Thoraval [EMAIL PROTECTED] writes: I have been trying this example not executing the GRANT UPDATE statement at first to check that user b doesn't have the right to update. The problem is that even though B was not granted the update privilege

[GENERAL] TEXT field's length limit in PostgreSQL

of more than 4096 bytes size, for example article - do I really have to put it in the LOB field and use these terrific lo-functions to access it ?? Please, if anyone can help me - write to [EMAIL PROTECTED] . Thx in advance, Michael 'Samuel' Modestowicz ---(end

Re: [GENERAL] Serial not so unique?

)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Michael Samuel Tech Guy [EMAIL PROTECTED

Re: [GENERAL] Vacuum-ing without disconnecting users

, by issuing the command but not locking the table. Hopefully it goes into the TO DO list. Thank's Andy - Original Message - From: Thalis A. Kalfigopoulos [EMAIL PROTECTED] To: Andy Samuel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 14, 2001 1:40 AM Subject: Re: [GENERAL

Re: [GENERAL] What the heck is happening here?

Paul Tomblin a écrit : Quoting Alex Pilosov ([EMAIL PROTECTED]): While I think its a great idea for quality of DBD::Pg (Edmund, with all due respect, does not scale :), it needs to be agreed with Edmund first, and CPAN releases of DBD::Pg should continue, based on snapshots from

Re: [GENERAL] Thanks and questions...

On Fri, Jul 28, 2000 at 06:53:41PM -0400, Tom Lane wrote: George Robinson II [EMAIL PROTECTED] writes: What approach would be the most efficient way to accomplish this goal? With what language or tools would you recommend? If I were to leave the time as a int4, epoch time, what would

[GENERAL] startup script

Does anyone have a startup script for Postgres 7.0 that I can throw into my /etc/rc.d/init.d directory? (RedHat 6.1) Thanks, Sam -- _ / Samuel A. Mullen \ | Programmer Analyst |___ | Opportunities Unl. | More

[GENERAL] ODBC Question for 7.0

would be greatly appreciated. Sam -- _ / Samuel A. Mullen \ | Programmer Analyst |___ | Opportunities Unl. | Which by his strength setteth fast the\ \_/| mountains; [being] girded with power

[GENERAL] Postgres Tool Question

Are there any tools for generating reports for Postgres? I searched RedHat, Enterprise Linux, the HOWTO, and haven't found anything. Sam -- _ / Samuel A. Mullen \ | Programmer Analyst |___ | Opportunities Unl. | Of old

Re: [GENERAL] Postgres Tool Question

. As far as that little MS Access comment goes. It took me a long time to find a job where I just use Linux, I don't want to regress to Windows. :) Sam "Brett W. McCoy" wrote: On Tue, 9 May 2000, Samuel A. Mullen wrote: Are there any tools for generating reports for Postgres?

[GENERAL] deleting large objects

Is it possible to unlink large objects using SQL? I see import and export and I can unlink from a program, but is it possible to use a query to unlink them?