On Fri, Jun 7, 2019 at 2:35 PM Alvaro Herrera wrote:
> I envision this happening automatically -- you drop the partition, a
> persistent work item is registered, autovacuum takes care of it
> whenever. The user doesn't have to do anything about it.
We don't have to agree on anything now, but I t
On 2019-Jun-07, Peter Geoghegan wrote:
> On Fri, Jun 7, 2019 at 1:22 PM Alvaro Herrera
> wrote:
> > Because you can't rely on that exclusively, and you want to reuse the
> > partition ID eventually, you still need a cleanup process that removes
> > those remaining index entries. This cleanup p
On Fri, Jun 7, 2019 at 1:22 PM Alvaro Herrera wrote:
> Somehow we ended up discussing this topic in a rather mistitled thread
> ... oh well :-) (Nowadays I hesitate to change threads' subject lines,
> because gmail).
You can blame me for that, I think.
> > It occurs to me that we could add a co
Somehow we ended up discussing this topic in a rather mistitled thread
... oh well :-) (Nowadays I hesitate to change threads' subject lines,
because gmail).
On 2019-Jun-07, Peter Geoghegan wrote:
> On Fri, Jun 7, 2019 at 12:43 PM Alvaro Herrera
> wrote:
> > Well, "quickly" might mean within a
On Fri, Jun 7, 2019 at 12:43 PM Alvaro Herrera wrote:
> Well, "quickly" might mean within a week. If it takes that long to
> fully remove a monthly partition to make that partition ID available to
> some future month's partition, that seems acceptable. Blocking
> DROP/DETACH for one hour is cert
On 2019-Jun-07, Peter Geoghegan wrote:
> On Fri, Jun 7, 2019 at 12:18 PM Alvaro Herrera
> wrote:
> > I was thinking of asynchonously cleaning it up rather than blocking
> > DROP/DETACH ... which means you need to keep state somewhere. I don't
> > think blocking DROP/DETACH is valuable -- a glob
On Fri, Jun 7, 2019 at 12:18 PM Alvaro Herrera wrote:
> I was thinking of asynchonously cleaning it up rather than blocking
> DROP/DETACH ... which means you need to keep state somewhere. I don't
> think blocking DROP/DETACH is valuable -- a global index that blocks
> DROP/DETACH until the index
>
> I was thinking of asynchonously cleaning it up rather than blocking
> DROP/DETACH ... which means you need to keep state somewhere. I don't
> think blocking DROP/DETACH is valuable -- a global index that blocks
> DROP/DETACH until the index is clean serves no useful purpose. (You
> could thi
Hello All,
I ended up removing all configuration. Re-unzip the binary tar files we
downloaded. Re-configure with the option "--with-systemd" and now it is
working.
We really appreciate all your help!
Dan
-Original Message-
From: Lu, Dan
Sent: Friday, June 07, 2019 10:11 AM
To: 'Tom
On 2019-Jun-07, Peter Geoghegan wrote:
> On Fri, Jun 7, 2019 at 9:10 AM Alvaro Herrera
> wrote:
> > I think vacuuming for global indexes is somewhat challenging as well :-)
> > Maybe not as much as for indirect indexes, that's true.
> >
> > In order for it to be sustainable, I think you'll want
On Fri, Jun 7, 2019 at 9:10 AM Alvaro Herrera wrote:
> I think vacuuming for global indexes is somewhat challenging as well :-)
> Maybe not as much as for indirect indexes, that's true.
>
> In order for it to be sustainable, I think you'll want to reuse
> partition identifiers when the partitions
On 2019-Jun-07, Peter Geoghegan wrote:
> On Thu, Jun 6, 2019 at 3:00 PM David Rowley
> wrote:
> > You may already be aware, but another use case for such variable-width
> > identifiers was with indirect indexes as discussed in [1]
>
> Right. I went with global indexes because indirect indexes ar
On Thu, Jun 6, 2019 at 3:00 PM David Rowley
wrote:
> You may already be aware, but another use case for such variable-width
> identifiers was with indirect indexes as discussed in [1]
Right. I went with global indexes because indirect indexes are
probably a lot more risky as a project. I'd be par
On 6/6/19 6:50 AM, Karsten Hilbert wrote:
>> The current canonical solution (?) for verifying checksums in
>> an existing database is, to may understanding, to pg_dump it
>> (to /dev/null, perhaps):
>> as that will read and verify all blocks related to the dump
>> of that database.
FWIW, that does
On 6/6/19 6:50 AM, Karsten Hilbert wrote:
Now that it is established that CREATE DATABASE does not
verify checksums on the template I have a followup question.
The current canonical solution (?) for verifying checksums in
an existing database is, to may understanding, to pg_dump it
(to /dev/null
Lu:
On Fri, Jun 7, 2019 at 3:48 PM Lu, Dan wrote:
> Even with the added option “—with-systemd”, it is not working still.
> Status remains “ Active: activating (start) since Fri 2019-06-07 09:40:06
> EDT; 13s ago”.
> To outline what I did.
> 1) Stop PostgreSQL instance running with “/hostname/
I apologize, it was a copy/paste error. I did include the option
"--with-systemd".
This is our first install of postgresql. I am in the process of getting
standard in place for future deployment. We don't have any large footprint of
postgresql here. We run mostly Oracle, SQL Server and MySQ
"Lu, Dan" writes:
> Even with the added option “—with-systemd”, it is not working still.
Hmmm
> To outline what I did.
> 2) Configure PostgreSQL to new location
> mkdir /hostname/pg/PostgreSQL-10.7_2
> ./configure --prefix=/hostname/pg/PostgreSQL-10.7_2
Is it just a copy-and-paste mistak
Even with the added option “—with-systemd”, it is not working still.
Status remains “ Active: activating (start) since Fri 2019-06-07 09:40:06
EDT; 13s ago”.
To outline what I did.
1) Stop PostgreSQL instance running with “/hostname/pg/PostgreSQL-10.7”
configuration which was compiled witho
Adrien Nayrat writes:
> Postgres' stemmer has been synced with Snowball upstream, but it was before
> October:
> https://www.postgresql.org/message-id/E1g4YQa-0003tf-Gr%40gemulon.postgresql.org
> We are now in 12 beta 1 and far after feature freeze, so I am afraid your
> request to add greek cou
Hi Frank,
Il giorno ven, 07/06/2019 alle 13.58 +0200, Ict Security ha scritto:
> Dear guys,
>
> i have two identical Postgresql 9.6.1 and i need, to test an
> application, to reach connection above 1024.
>
> I setup 2400 as max_connections
> I raised file-max kernel limit to 65535
> I increased
Ict Security wrote:
> i have two identical Postgresql 9.6.1 and i need, to test an
> application, to reach connection above 1024.
>
> I setup 2400 as max_connections
Ugh. Don't. Use a connection pool.
> I raised file-max kernel limit to 65535
> I increased shared_buffers
> I also increased the
Thank you so much for pointing that out.
I downloaded the binary from https://ftp.postgresql.org/pub/source/v10.7
After download, I did the following.
mkdir /hostname/pg/PostgreSQL-10.7_2
./configure --prefix=/hostname/pg/PostgreSQL-10.7_2
make
make install
I now included the option ment
Sorry, I recognized that it was not "/" who caused the problem. I'm doing this
in a java program and if I pause the program before running psql.exe and just
open the csv file in windows with Excel and close it (without doing anything
else) and then let the program run again. Then it works!
Coul
Paul Malm wrote:
> C:\Users\an\bin>C:\Tmp\psql -h 10.211.43.22 -p 5432 -U postgres -d aatest -w
> -c "\copy public.""Bayern"" FROM 'C:\Users\an\test\Bayern.csv' WITH
> DELIMITER ';' CSV"
> Error: extra data after expected last column
> CONTEXT: COPY Bayern, row 1:
> "48.456;
Dear guys,
i have two identical Postgresql 9.6.1 and i need, to test an
application, to reach connection above 1024.
I setup 2400 as max_connections
I raised file-max kernel limit to 65535
I increased shared_buffers
I also increased the value in semaphores in both
And i added this in limits.conf:
As I haven't heard regarding the runtime error, I'd like to ask again for the
question #2.
Does anyone know that including Postgresql setup exe and pgAdmin setup exe in
my installer doesn't violate the copyright/licensing policy?
On 6/7/19 5:01 AM, paul.m...@lfv.se wrote:
Hi, I have a problem with psql and CSV.
C:\Users\an\bin>C:\Tmp\psql -h 10.211.43.22 -p 5432 -U postgres -d aatest
-w -c "\copy public.""Bayern"" FROM 'C:\Users\an\test\Bayern.csv' WITH
DELIMITER ';' CSV"
Error: extra data after expected last col
Tom:
On Fri, Jun 7, 2019 at 2:19 AM Tom Lane wrote:
> Francisco Olarte writes:
> > On Thu, Jun 6, 2019 at 6:57 PM Kelly, Kevin wrote:
> > and is running, notify means it does systemd integration via socket,
> > with IIRC postgres does not.
>
> I might be confusing this with some other issue, b
On 6/7/19 12:19 PM, Tasks wrote:
> 😢 is there a solution to that?
> Is it possible that we add it ourselves ???
>
> Has anyone worked with this extension ->
> https://github.com/postgrespro/snowball_ext
>
> Tassos
>
I did not played with this extension, maybe you can add greek to
https://git
😢 is there a solution to that?
Is it possible that we add it ourselves ???
Has anyone worked with this extension ->
https://github.com/postgrespro/snowball_ext
Tassos
7 Ιουν 2019, 1:12 μμ, ο χρήστης «Adrien Nayrat »
έγραψε:
>> On 6/7/19 10:31 AM, Tasos wrote:
>> Hi to all,
>>
>> Since Oct
On 6/7/19 10:31 AM, Tasos wrote:
> Hi to all,
>
> Since Oct 2018 -
> Greekhttps://www.postgresql.org/message-id/E1g4YQa-0003tf-Gr%40gemulon.postgresql.org
> stemming algorithm contributed by Oleg Smirnov is in
> inclued in the Snowball project.
>
> I believe it can be included in the Release
Hi, I have a problem with psql and CSV.
C:\Users\an\bin>C:\Tmp\psql -h 10.211.43.22 -p 5432 -U postgres -d aatest -w
-c "\copy public.""Bayern"" FROM 'C:\Users\an\test\Bayern.csv' WITH DELIMITER
';' CSV"
Error: extra data after expected last column
CONTEXT: COPY Bayern, row 1:
"48.4
Greek stemming algorithm is already available at the snowballstem site.
(Oct 2018)
Lets hope the integration happens before the next release.
On Fri, Jun 7, 2019 at 11:49 AM Tasos wrote:
> Καλησπέρα Αχιλλέα και ευχαριστώ για την απάντηση, το snowball ->
> https://snowballstem.org/ με τα δικά τ
On 7/6/19 11:48 π.μ., Tasos wrote:
Καλησπέρα Αχιλλέα και ευχαριστώ για την απάντηση, το snowball ->
https://snowballstem.org/ με τα δικά του λόγια
"*Snowball* is a small string processing language designed for creating stemming
algorithms for use in Information Retrieval."
Ερώτηση, νόμιζα είναι
Καλησπέρα Αχιλλέα και ευχαριστώ για την απάντηση, το snowball -> https://snowballstem.org/ με τα δικά του λόγια
"Snowball is a small string processing language designed for creating stemming algorithms for use in Information Retrieval."
Ερώτηση, νόμιζα είναι παγκόσμια λίστα μιλάμε αγγλικά ή
On 7/6/19 11:31 π.μ., Tasos wrote:
Hi to all,
Since Oct 2018 - Greek stemming algorithm contributed by Oleg Smirnov is in
inclued in the Snowball project.
Για σου Τασσο, μπορείς να εξηγήσεις τι εστί Snowball?
I believe it can be included in the Release 12 of postgres
Best Regards,
Bard
--
Hi to all,
Since Oct 2018 - Greek stemming algorithm contributed by Oleg Smirnov is in inclued in the Snowball project.
I believe it can be included in the Release 12 of postgres
Best Regards,
Bard
38 matches
Mail list logo
