Re: postgresql-10.3 on unbuntu-17.10 - how??

etty much moot >> except for a few unfortunates like me who absolutely need 10.3 but have no >> option to upgrade. I guess the lesson is that running the Pgdg versions >> of Postgresql on any but the LTS versions of Ubuntu is pretty risky. >> Live and learn. Maybe this will help someone else. I have followed more than once the exact directions from the download page: https://www.postgresql.org/download/linux/ubuntu/ Just pretend you are running 17.10 instead of 17.04. It simply works. -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS

Re: PostgreSQL suitable?

I think that table partitioning isn't suitable yet for a large number of partitions. Or a large number of partial indexes. This will be a challenge too. Il 19 dic 2017 15:07, "Kellner Thiemo" ha scritto: > Hi > > We are developing a data warehouse of which the integration layer will > start wit

Re: PostgreSQL suitable?

I've not tested PG10. But it's not released for production yet! Il 19 dic 2017 15:48, "Andreas Kretschmer" ha scritto: > > > Am 19.12.2017 um 15:07 schrieb Kellner Thiemo: > >> Hi >> >> We are developing a data warehouse of which the integration layer will >> start with over 100 TB of data. Ther

Re: PostgreSQL suitable?

ha scritto: > Vincenzo Romano wrote: > > I've not tested PG10. But it's not released for production yet! > > It definitely is, for a couple of months now. 10.1 (the first bugfix > release) has been out for over a month. > > -- > Álvaro Herrera

Re: PostgreSQL suitable?

2017-12-19 16:48 GMT+01:00 Stephen Frost : > * Vincenzo Romano (vincenzo.rom...@notorand.it) wrote: >> Sorry, my bad: I confused V10 with v11. >> But accordingly to a discussion with Bruce Momjan, table partitionin V10 is >> little more than syntactic sugar around old-fashion

Re: PostgreSQL suitable?

Hi. 2017-12-19 17:32 GMT+01:00 Stephen Frost : > Greetings, > > * Vincenzo Romano (vincenzo.rom...@notorand.it) wrote: >> 2017-12-19 16:48 GMT+01:00 Stephen Frost : >> > * Vincenzo Romano (vincenzo.rom...@notorand.it) wrote: >> >> Sorry, my bad: I confused V10

[v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X

Source code | Description +--+--+-+--++--+---+--+---+--+-+- (0 rows) but this succeeds: tmp2=# select * from pg_temp.x(); b --- t (1 row) I think I am doing/thinking something wrong. But what? TALIA! -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS

Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X

2017-12-21 17:52 GMT+01:00 Tom Lane : > Vincenzo Romano writes: >> It seems I cannot use a temporary function. > > You have to schema-qualify the temp function name when calling it, too. > > regards, tom lane Hi. So search_path is not used with fun

Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X

2017-12-21 17:56 GMT+01:00 Tom Lane : > Vincenzo Romano writes: >> 2017-12-21 17:52 GMT+01:00 Tom Lane : >>> You have to schema-qualify the temp function name when calling it, too. > >> So search_path is not used with functions? > > pg_temp is explicitly ign

Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X

2017-12-22 0:50 GMT+01:00 Melvin Davidson : > > > > On Thu, Dec 21, 2017 at 12:07 PM, Vincenzo Romano > wrote: >> >> 2017-12-21 17:56 GMT+01:00 Tom Lane : >> > Vincenzo Romano writes: >> >> 2017-12-21 17:52 GMT+01:00 Tom Lane : >> >

Re: 5 USD for PostgreSQL books at PacktPub

ordered > https://www.packtpub.com/big-data-and-business-intelligence/mastering-postgresql-10 > > Regards > Alex Those are e-books, though, not dead tree books. -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS

Re: Production Database requirement

l advise. > 2. Can we use Vm's to run the Db? Is it recommended ? There's nothing against virtualization apart the computing and I/O limits it can pose. In general, real hardware can provide for better performances. > Thanks in Advance! > > > -- > > Regards, >

Re: help with generation_series in pg10

Support, Remote DBA, Training & Services > You can add a generated series as seconds, minutes, hours ... to a base timestamp. Yes, it's not an easy going expression, but I'd do it like this. -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS

Re: How Many Partitions are Good Performing

entry=gmail&source=g> > New York, NY 10017 > <https://maps.google.com/?q=335+Madison+Ave.%C2%A0New+York,+NY%C2%A010017&entry=gmail&source=g> > http://www.timescale.com/ > https://github.com/timescale/timescaledb > The data about the query performances would have shed more light on the situation. Unluckily there's none. Weird! -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS

Re: Notify client when a table was full

2018-01-21 19:31 GMT+01:00 Francisco Olarte : > On Sun, Jan 21, 2018 at 1:27 PM, Michael Paquier > wrote: >> On Fri, Jan 19, 2018 at 03:40:01PM +, Raymond O'Donnell wrote: > ... >>> How do you define "full"? The only possible and meaningful case, IMHO, as stated by David earlier, is "file sys

Re: Best non-networked front end for postgresql

s well as a number of other languages ranging from C, C++, Java, PHP. Almost all languages have a "module" to interact with Postgres databases. The best one is IMHO the one you know the best. P.S. The differences between a local Unix socket and a TCP one are rather subtle from your point of view. -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS

Re: Notify client when a table was full

2018-01-22 14:58 GMT+01:00 John McKown : > On Mon, Jan 22, 2018 at 2:07 AM, Steve Atkins wrote: >> >> >> > On Jan 21, 2018, at 6:44 PM, Vincenzo Romano >> > wrote: >> > >> > 2018-01-21 19:31 GMT+01:00 Francisco Olarte : >> >>

Re: PGSQL 10, many Random named DB

4.) "Alien invasion", etc. >> >> Did you see same thing anywhere? >> >> Thank you for any advice in this theme! >> >> Best regards >>dd > > > > > I bet on 2. > probably did not setup pg_hba.conf file. > > Regards, >

Re: PostgreSQL 9.6: view based on sequence

--+-+--- 1 | 0 | f (1 row) Maybe what you want to do is create view v_test_sequence as select nextval( 'test_sequence' ); Ciao. -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS

Re: PostgreSQL 9.6: view based on sequence

p.it > I haven't any v9 any more in my deployments. Sorry. What is the objective of that view? If it's to hide the nextval() function, then the solution can be similar to mine. If it's to access the sequence metainfo, then maybe it'd be better to explore the pg_catalog schema. -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS

Re: PostgreSQL 9.6: view based on sequence

2018-01-24 13:10 GMT+01:00 Enrico Pirozzi : > it's just to know why postgresql does not return a warning. > > > > Il 24/01/2018 13:06, Vincenzo Romano ha scritto: >> >> I haven't any v9 any more in my deployments. Sorry. >> >> What is the objec

Re: PostgreSQL 9.6: view based on sequence

2018-01-24 14:52 GMT+01:00 Enrico Pirozzi : > Yes the query is legal,but if you use pg_upgrade to upgrade from 9.6 to 10.x > , pg_upgrade will fail . > > Enrico > > > > Il 24/01/2018 13:11, Vincenzo Romano ha scritto: >> >> Those queries are all legal. No warni